Informatics Practices
Which of the following clauses is used to sort the result set?
- SORT BY
- GROUP BY
- ARRANGE BY
- ORDER BY
SQL Queries
1 Like
Answer
ORDER BY
Reason — The SQL ORDER BY clause is used to sort data in ascending or descending order based on one or more columns.
Answered By
1 Like
Related Questions
What will be the order of the data being sorted after the execution of given SQL query?
SELECT * FROM STUDENT ORDER BY ROLL_NO;- Custom Sort
- Descending
- Ascending
- None of these
Which values will not be considered by SQL while executing the following statement?
SELECT COUNT(column name) FROM DEPARTMENT;- Numeric value
- Text value
- Null value
- Date value
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)
If column "Marks" contains the data set {25, 35, 25, 35, 38}, what will be the output after the execution of the given query?
SELECT DISTINCT(MARKS) FROM STUDENTS;- 25, 35, 25, 35, 38
- 25, 25, 35, 35, 38
- 25, 35, 38
- 25, 25, 35, 35