I m currently using sql server management studio express to manage my database. I wish to sort the data in the database table. Firstly i wish to sort column 1 in according to alphabetic order and then sort colum 2 in alphabetic order. Can someone tell me what to do?
Sorting Data in Database
Collapse
X
-
Originally posted by gyap88I m currently using sql server management studio express to manage my database. I wish to sort the data in the database table. Firstly i wish to sort column 1 in according to alphabetic order and then sort colum 2 in alphabetic order. Can someone tell me what to do?
create an index...retreiv e the data from the table specifying the sort order... [ORDER BY...]
Comment