How to get 3rd Highest salary
-
Guys , This is a popular Interview question, i would like to know the various queries that can be written to achieve this. Table: Employee Columns: Name, Salary
-
Guys , This is a popular Interview question, i would like to know the various queries that can be written to achieve this. Table: Employee Columns: Name, Salary
Select TOP 1 Name,Salary From ( Select TOP 3 Name, salary from Employee order by Salary DESC ) as temp order by Salary ASC
Keep Smiling !!! Parwej Ahamad g_parwez@rediffmail.com
-
Guys , This is a popular Interview question, i would like to know the various queries that can be written to achieve this. Table: Employee Columns: Name, Salary
-
... and lip balm to prevent chapped lips while kissing all those butts.:-D
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before. -
ednrgc wrote:
knee pads
:laugh:
---Guy H (;-)---