Informatics Practices
To create summary results, …………… clause is used.
- SORT BY
- SUMMARY BY
- GROUP BY
- ORDER BY
SQL Queries
1 Like
Answer
GROUP BY
Reason — The GROUP BY clause in SQL is used to create summary results by grouping together all records that share identical values in a particular field or a group of fields.
Answered By
1 Like
Related Questions
By default, ORDER BY clause lists the results in …………… order.
- Descending
- Any
- Same
- Ascending
Which one of the following would arrange the rows in ascending order in SQL ?
- SORT BY
- ALIGN BY
- GROUP BY
- ORDER BY
Consider the following query
SELECT * FROM employee ORDER BY salary ..............., name ...............;To display the salary from greater to smaller and name in alphabetical order which of the following options should be used ?
- Ascending, Descending
- Asc, Desc
- Desc, Asc
- Descending, Ascending
Select correct SQL query from below to find the temperature in increasing order of all cities.
SELECT city FROM weather ORDER BY temperature ;
SELECT city, temperature FROM weather ;
SELECT city, temperature FROM weather ORDER BY temperature ;
SELECT city, temperature FROM weather ORDER BY city ;