how to get the first 10 max salaries of employees out of say 100 employees

hi,
i got a small pbrobs
i want to get first 10 max salaries out of 100 employees from my_tbl(ex)
i tried by writing subqueries..but i need a simple query to get itHow about posting your DDL, plus INSERT statements of sample data plus
expected results?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"joshithay via webservertalk.com" <forum@.webservertalk.com> wrote in message
news:542E98E7F30FA@.webservertalk.com...
hi,
i got a small pbrobs
i want to get first 10 max salaries out of 100 employees from my_tbl(ex)
i tried by writing subqueries..but i need a simple query to get it