Sorting Data in Database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gyap88
    New Member
    • Jul 2007
    • 37

    #1

    Sorting Data in Database

    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?
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Originally posted by gyap88
    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?

    create an index...retreiv e the data from the table specifying the sort order... [ORDER BY...]

    Comment

    Working...