Home Forums SQL Server 7,2000 T-SQL SQL RE: SQL

  • August 4, 2003 at 2:34 am

    #468382

    quote:

    Hello Mark

    I tried with another query which is as follows

    SELECT TOP 5 *

    FROM table

    However I am not getting the lowest 5. I tried with bottom, but it's not working

    what about

    ORDER BY salary (DESC) ?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]