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
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