Post reply

How to get the bottom 10 values in SQLsERVER

  • 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

  • June 9, 2011 at 3:41 pm

    #1336754

    no need to shout.

    create a top values query and sort in ascending order.

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply