How to retrieve the 7th row from the table

sridharvedula · New User Joined: 24 Mar 2005 Posts: 3

hi,

How to retrieve the 2nd min sal from the table?

How to retrieve the 7th row from the table?

plzz post the queries solution as early as possible

gaurchetan · New User Joined: 20 Mar 2005 Posts: 6

hi there,
i don't know about how to retrieve 7th row but for 2nd min sal the query is

select min(sal) from saltab
where sal not in (select min(sal) from saltab);
please let me know about how to retreive 7th row.

SINDHU · New User Joined: 22 Apr 2005 Posts: 2 Location: CHENNAI

Hi
Hope this query would help you.
select min(sal) from emp where sal>(select min(sal) from emp).

gvt460 · New User Joined: 04 Mar 2005 Posts: 23

i know how to fetch directly 7th row from table in application program only.
exec sql
declare cur sensitive static scroll cursor for select * from table
end-exec
exec sql
open cur
end-exec.
exec sql
fetch absolute 7 into :dcltab
end-exec.
exec sql
close cur
end-exec.

check this one.....