SQL Query to get the 3rd max. salary from a table

gvel19 · Posted: Mon Sep 29, 2008 12:13 pm

Hi,

1) I need a SQL query to fetch the 3rd maximum salary from a table.
2) Also need to get the list of employees (From table A) whose salary is greater than the average salary of the employees from another table (table B).

Thanks,
Vel

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

Vel, this is a forum not a software factory, it would be good if you could post what you have tried so far.

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

To select the third max. You can try this.

gvel19 · Posted: Mon Sep 29, 2008 1:37 pm

Thanks a lot birdy.

Acevedo : I'm extremely sorry for that. I have tried but didn't get any hint for the query.

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

a search for THIRD in the DB2 forum:

how to get third largest element in a table?

sql query, second or third top employee..

hth