Please match the keyword or operator from the list below to its correct SQL explanation and syntax in the table. Replace ? with a correct option from the following list: HAVING clause, ORDER BY clause, LIMIT clause, Inbuilt Aggregate Functions, GROUP BY clause, WHERE clause Keyword/Operator Explanation Syntax ? Limit the number of rows to be displayed SELECT * FROM LIMIT ; ? To filter rows SELECT * FROM WHERE ; ? To sort the rows of the table SELECT * FROM ORDER BY ASC|DESC; ? Summarize information from multiple rows and display it as single row SELECT (), () FROM Function names include SUM, COUNT, MIN, MAX, AVG ? To display summary information by groups SELECT , (), () FROM GROUP BY ; ? To filter results of aggregated table SELECT , (), () FROM GROUP BY HAVING ;
Please match the keyword or operator from the list below to its correct SQL explanation and syntax in the table.
Replace ? with a correct option from the following list: HAVING clause, ORDER BY clause, LIMIT clause, Inbuilt Aggregate Functions, GROUP BY clause, WHERE clause
|
Keyword/Operator |
Explanation |
Syntax |
|
? |
Limit the number of rows to be displayed |
SELECT * FROM <table name> LIMIT <number of rows>; |
|
? |
To filter rows
|
SELECT * FROM <table name> WHERE <condition>; |
|
? |
To sort the rows of the table
|
SELECT * FROM <table name> ORDER BY <column name(s)> ASC|DESC; |
|
? |
Summarize information from multiple rows and display it as single row
|
SELECT <function name 1> (<column name 1>), <function name 2> (<column name 2>) FROM <table name>
Function names include SUM, COUNT, MIN, MAX, AVG |
|
? |
To display summary information by groups
|
SELECT <grouping attribute>, <FUNCTION1> (<column name 1>), <FUNCTION2> (<column name 2>) FROM <table name> GROUP BY <grouping attribute>; |
|
? |
To filter results of aggregated table
|
SELECT <grouping attribute>, <FUNCTION1> (<column name 1>), <FUNCTION2> (<column name 2>) FROM <table name> GROUP BY <grouping attribute> HAVING <condition>; |
Step by step
Solved in 2 steps
