SQL query to find the 2nd highest salary using Fetch First.

arindambanerjee · New User Joined: 30 Jun 2007 Posts: 39 Location: India

Hi All,

Can you please suggest if the below SQL query will extract the details of the employee with 2nd highest salary from EMP table:

Select * from EMP where sal=(
(select sal from EMP having sal=max(sal) fetch first 2 rows only ordered by descending)
) fetch first 1 row only ordered by ascending;;;

dbzTHEdinosauer · Posted: Wed Dec 09, 2009 10:17 pm

suggest you run it in spufi or qmf.

dick scherrer · Posted: Wed Dec 09, 2009 10:29 pm

Hello,

And you saw some reason to re-post this? Your original was moved to Homework from this part of the forum as it is a standard" homework assignment.

Post a question only once. . .

This dulicate is locked. . .

d