ORDER BY

This is a sorting function.

This is used after the columns and rows have been selected

The renames tables may be used in the ORDER BY

By default, the ASC is ubed by the machine. If you want to make it descending order, then DESC will have to be specified.

#GROUP BY CLAUSE

SELECT NAME, COUNT(*) AS mumber_of_times
FROM col$
WHERE COL# = 1
GROUP BY NAME
HAVING COUNT(*) > 5
ORDER BY mumber_of_times DESC;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top