select max(sal) from emp where rownum=2 group by sal

How to select particular number using rownum?
Example: i need only the second max number using rownum.

Question Posted / harika

2 Answers
7404 Views
Maveric, I also Faced
E-Mail Answers

Answer Posted / harika

select max(sal) from emp where rownum=2 group by sal

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2178

mount: mount to NFS server failed: System Error: Connection timed out

3626

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2491

what is the instrument that used in Mechanical Energy??

2626

what is new g/l functionality

2570