+ 1

hey what if i want to order my columns in descending order? is it possible? if yes, how to do that?

20th Jun 2016, 11:59 PM
Sagar Mulchandani
Sagar Mulchandani - avatar
7 Respostas
0
SELECT ColumnName1 FROM TableName order by ColumnName1 desc -->You must use same column name in select and order by
21st Jun 2016, 12:49 AM
Hossein Tavasolnia
Hossein Tavasolnia - avatar
0
select column from abc order by column range desc
21st Jun 2016, 4:33 AM
Kadiveti Kalyan Kumar
Kadiveti Kalyan Kumar - avatar
0
select c_name from t_name order by c_name desc;
21st Jun 2016, 5:55 PM
Abhishek singh
Abhishek singh - avatar
0
select column_name from table_name order by column_name desc;
22nd Jun 2016, 1:30 PM
Gaurav Srivastava
Gaurav Srivastava - avatar
0
select column_name from table_name order by column_name desc; visit w3schools.com and go to learn sql and click on order by section...u will fibd details over there.
23rd Jun 2016, 12:41 AM
Alfahad Mahimi
Alfahad Mahimi - avatar
0
<SQL statement> order by ColumnName desc
26th Jun 2016, 9:10 AM
Sai Kartheek
Sai Kartheek - avatar
0
yes and also included rank... select salary from(select salary,rank() desc(order by desc)rnk from table_name) where rnk =1;
26th Jun 2016, 12:14 PM
Abhishek singh
Abhishek singh - avatar