The DESC keyword is
used to sort the record in descending order. This keyword is used with the
ORDER BY expression.
Syntax:
SELECT column1,
column2.. FROM your_table_name ORDER BY column_name DESC;
Example:
Id
|
Name
|
Age
|
Address
|
1
|
Alok Kumar Singh
|
30
|
IN
|
2
|
Tomas Paul
|
45
|
NZ
|
3
|
Cristomfer Dee
|
85
|
AU
|
4
|
Niel Macengi
|
55
|
US
|
USE SQLCLR
GO
SELECT * FROM EMPLOYEE ORDER BY Name DESC
GO
Id
|
Name
|
Age
|
Address
|
Department
|
Gender
|
2
|
Tomas Paul
|
45
|
NZ
|
IT
|
Male
|
4
|
Niel Macengi
|
55
|
US
|
BPO
|
Female
|
3
|
Cristomfer Dee
|
85
|
AU
|
HR
|
Female
|
1
|
Alok Kumar Singh
|
30
|
IN
|
IT
|
Male
|
No comments:
Post a Comment