What Is Order By Clause In Dmbs?

1.	What Is Order By Clause In Dmbs?
Answer» ORDER BY clause helps to SORT the data in EITHER ascending order to descending order. Ascending order sort query : SELECT NAME,AGE FROM pcdsEmployee ORDER BY age ASC. Descending order sort query : SELECT name FROM pcdsEmployee ORDER BY age DESC. ORDER BY clause helps to sort the data in either ascending order to descending order.

Answer»

ORDER BY clause helps to SORT the data in EITHER ascending order to descending order.

Ascending order sort query : SELECT NAME,AGE FROM pcdsEmployee ORDER BY age ASC.
Descending order sort query : SELECT name FROM pcdsEmployee ORDER BY age DESC.

ORDER BY clause helps to sort the data in either ascending order to descending order.

Discussion