Results 1 to 2 of 2

Thread: How to order a column data

  1. #1
    Join Date
    Sep 2015
    Posts
    2

    How to order a column data

    I am using SQL server database and my table has below data.

    TEAM COUNTS
    Team1 1
    Team10 2
    Team2 10
    Team3 33
    Team4 66
    Team7 24
    Team6 23
    Team5 55

    What is the query to order Column "TEAM" in ascending order

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    select * from table order by team

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •