How to get the bottom 10 values in SQLsERVER

• ash0550

  Mr or Mrs. 500

  Points: 517

  More actions

  June 9, 2011 at 3:38 pm

  #251690

  i have been trying to get the bottom values in SQL but seems not to work

  Could someone help me on that

• pietlinden

  SSC Guru

  Points: 63578

  More actions

  June 9, 2011 at 3:41 pm

  #1336754

  no need to shout.

  create a top values query and sort in ascending order.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 9, 2011 at 3:41 pm

  #1336755

  Please don't post in all caps. It's the online equivalent of shouting at people.

  SELECT TOP (10) <column list>

  FROM <Some tables>

  ORDER BY <column that defines the required ordering> DESC

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• ash0550

  Mr or Mrs. 500

  Points: 517

  More actions

  June 9, 2011 at 3:44 pm

  #1336756

  GilaMonster (6/9/2011)

  ---

  Please don't post in all caps. It's the online equivalent of shouting at people.

  SELECT TOP (10) <column list>

  FROM <Some tables>

  ORDER BY <column that defines the required ordering> DESC

  Thanks for that

  I didnt know that And I edited it already

  My mistake