Take a look at the TOP clause in sql select...
TOP nExpr [PERCENT]
Specifies the query result contain a specific number of rows or a percentage of rows of the query result. You can specify from 1 to 32,767 rows. If you include the PERCENT option, permissible values for nExpr are 0.01 to 99.99. When you include the PERCENT option, the number of rows returned in the result is rounded up to the next highest integer.
>Hi All,
>
>I'm facing a problem to write a Query.
>Query is..
>I want Top Two highest salaried employee details of each Department.
>
>Table Name : EmpSalary
>Table Stru : Emp_ID, Emp_Name, Salary, Deptt
>
>Thanks
>Ravi
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown