in DBMS by

ORDER BY clause: This clause is used to define the order of the query output either in ascending (ASC) or in descending (DESC). Ascending (ASC) is set as the default one but descending (DESC) is set explicitly.


SELECT column_name(s)

 FROM table_name

 WHERE condition

 ORDER BY column_name ASC|DESC;

Related questions

0 votes
0 votes
asked Sep 9, 2019 in Spark Sql by ivor2019
0 votes
0 votes
asked Mar 31, 2020 in DBMS by amita rallin
0 votes
asked Dec 15, 2020 in Sql by SakshiSharma