Post reply

select low 10 values

  • April 9, 2004 at 7:10 am

    #110836

    There is option to select top 10 * from  sales

    but now i want to select botton 10 from sales

    there is any thing to like top to get botton up values

    by

    thani

  • April 9, 2004 at 7:17 am

    #502286

    Well use select top10 * from sales order by identitycolumn desc.

     

    Thanks

    Prasad Bhogadi
    www.inforaise.com

  • April 9, 2004 at 7:19 am

    #502287

    sorry for the typing mistake

    select top 10 * from sales order by [identitycolumn or Primary key or what ever the criteria] desc

    Thanks

     

    Prasad Bhogadi
    www.inforaise.com

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

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