+ 1
hey what if i want to order my columns in descending order? is it possible? if yes, how to do that?
7 Antworten
0
SELECT ColumnName1 FROM TableName
order by ColumnName1 desc
-->You must use same column name in select and order by
0
select column from abc
order by column range desc
0
select c_name from t_name order by c_name desc;
0
select column_name from table_name order by column_name desc;
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.
0
<SQL statement> order by ColumnName desc
0
yes and also included rank...
select salary from(select salary,rank() desc(order by desc)rnk from table_name) where rnk =1;