Order BY | Ascending | descending query in sql server 2005-2008

SELECT        cl_id, cl_name, cl_lst_name, cl_phone, cl_sal
FROM            clnt_tb
ORDER BY cl_lst_name

or

select * from  clnt_tb order by cl_lst_name

2	rama	hihi	8869	8889
3	ramayan	rahi	443434343	12345
1	ram	singh	898979999	10000

SELECT        cl_id, cl_name, cl_lst_name, cl_phone, cl_sal
FROM            clnt_tb
ORDER BY cl_lst_name DESC

or

select * from  clnt_tb order by cl_lst_name  desc

1	ram	singh	898979999	10000
3	ramayan	rahi	443434343	12345
2	rama	hihi	8869	8889

so , we got the idea how to use order by in  sql server with ascending order and descending order .
by default query execute ascending order.

Share This