quote:
Hello MarkI 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]