+ 1
How to implement 'order by' in descending order
12 Antworten
+ 6
select * from table order by column desc ;
+ 6
SELECT * FROM tableName ORDER BY ColumnName DESC;
+ 4
Order by_______ desc
+ 2
select * from table_name order by column_name desc;
+ 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.
+ 1
By default order by places the result in ascending order. For descending you have to mention desc keyword.
order by column_name desc;
+ 1
Order by desc
+ 1
select * from tablename order by desc;
0
Select * from table column order by asce
0
select columns from tablename order by desc;
0
select * from <tablename> orderby <column name> desc;
0
last give 'desc'