| Difference between DESC and ASC keywords
Below are the five main difference between DESC and ASC
(1)ASC:-It is short form of ascending
(1)DESC:-It is short form of descending
(2)ASC:-This keyword is used to sort the query result in top to bottom style.
(2)DESC:-This keyword is used to sort the query result in bottom to top style.
(3)ASC:-When doing on date data types the earlies dat is shown on the top of the list.
(3)DESC:-When doing on date data type the latest date is shown on top of the list.
(4)ASC:-When working with numeric data types the lowest values are shown on the top of the list.
(4)DESC:-When working with numeric data types the higest value shown on the top of query result.
(5)ASC:-On string data types it will show result in a to z form. A is shown first followed by Z.
(5)DESC:-It is just opposite of ASC | | |