Intermediate SQL Concepts

What SQL clause is used to filter records?

• WHERE

• GROUP BY

• SELECT

• JOIN

How do you sort the results of a query in ascending order?

• Use 'SORT BY column_name' in your SQL query.

• Invoke 'FILTER BY column_name ASC' in your SQL statement.

• Use 'ORDER BY column_name ASC' in your SQL query.

• Apply 'GROUP BY column_name' to arrange results.

Which SQL statement is used to retrieve data from a database?

• SELECT

• DELETE

• INSERT

• UPDATE

What is the purpose of the GROUP BY clause?

• To filter rows based on a condition.

• To group rows that have the same values in specified columns.

• To sort rows in ascending order.

• To join multiple tables together.

How can you limit the number of records returned by a query?

• Use the 'ORDER BY' clause to sort records.

• Apply a 'GROUP BY' clause to aggregate results.

• Use the 'SELECT ALL' statement to retrieve all records.

• Use the 'LIMIT' clause in SQL queries.

What does the HAVING clause do in SQL?

• The HAVING clause deletes records from the database.

• The HAVING clause filters records after aggregation.

• The HAVING clause creates new tables in SQL.

• The HAVING clause sorts records before aggregation.

Which operator is used to specify multiple possible values in a WHERE clause?

• AND

• LIKE

• OR

• IN

How do you select unique values from a column in SQL?

• SELECT column_name FROM table_name WHERE DISTINCT;

• SELECT column_name FROM table_name GROUP BY column_name;

• SELECT UNIQUE column_name FROM table_name;

• SELECT DISTINCT column_name FROM table_name;

What is the difference between WHERE and HAVING clauses?

• WHERE is used for sorting data; HAVING is for filtering data.

• WHERE can only be used with GROUP BY; HAVING cannot be used with GROUP BY.

• WHERE filters rows before aggregation; HAVING filters after aggregation.

• WHERE applies to all SQL statements; HAVING is specific to SELECT statements.

How can you combine results from multiple tables in SQL?

• Use GROUP BY to merge results

• Combine tables by copying data manually

• Use JOIN operations or UNION to combine results from multiple tables.

• Use SELECT statements only