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

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

1863


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.

2162


what is new g/l functionality

2209


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

3288


what is the instrument that used in Mechanical Energy??

2258