Informatics Practices
Write an example query that sorts on three columns.
SQL Queries
7 Likes
Answer
SELECT * FROM DATA
ORDER BY marks ASC, section DESC, term ASC;
Answered By
2 Likes
Related Questions
What is the use of ORDER BY clause ?
What is the default sort order of ORDER BY clause ?
Write a query that sorts the data of table student on the basis of Project-Group (in ascending order), section (in descending order), Marks (in descending order).
What is the difference between HAVING and WHERE clause ?