Informatics Practices
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
SQL Queries
2 Likes
Answer
Ascending
Reason — By default, ORDER BY clause sorts the result set in ascending order. Since the query does not include DESC, the data will be sorted in ascending order based on the ROLL_NO column.
Answered By
1 Like
Related Questions
Argument type of AVG() function can be numeric or string data type.
Group functions can be applied to any numeric values, some text types and DATE values.
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 of the following clauses is used to sort the result set?
- SORT BY
- GROUP BY
- ARRANGE BY
- ORDER BY