How to implement 'order by' in descending order | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

How to implement 'order by' in descending order

7th Jan 2017, 8:25 AM
K Pranay
K Pranay - avatar
12 Answers
+ 6
select * from table order by column desc ;
7th Jan 2017, 4:50 PM
Naoufal ROUGUINE
+ 6
SELECT * FROM tableName ORDER BY ColumnName DESC;
11th Jan 2017, 5:37 PM
Rishi Thakur
Rishi Thakur - avatar
+ 4
Order by_______ desc
7th Jan 2017, 9:11 AM
bar Levitzky
+ 2
select * from table_name order by column_name desc;
15th Feb 2017, 1:38 PM
Arun
+ 1
let's suppose customer is a table from which nowe need to fetch only those customers details who have been added recently in the table, so we can use below query. select * from customer order by ctdb_cre_datetime desc; I am referring ctdb_cre_date as a column name where customer creation date & time is being updated.
8th Jan 2017, 10:10 PM
Sumit Prasad
Sumit Prasad - avatar
+ 1
By default order by places the result in ascending order. For descending you have to mention desc keyword. order by column_name desc;
9th Jan 2017, 7:59 AM
Sheema Parwaz
+ 1
Order by desc
10th Jan 2017, 2:36 PM
Priya Karwa
Priya Karwa - avatar
+ 1
select * from tablename order by desc;
11th Jan 2017, 5:58 PM
Abhishek Shukla
Abhishek Shukla - avatar
0
Select * from table column order by asce
12th Jan 2017, 5:27 AM
Myat Kyaw
Myat Kyaw - avatar
0
select columns from tablename order by desc;
18th Jan 2017, 6:00 PM
srinath
0
select * from <tablename> orderby <column name> desc;
22nd Jan 2017, 10:46 PM
mahendra mahajan
mahendra mahajan - avatar
0
last give 'desc'
23rd Jan 2017, 11:31 AM
Arshad m.p