How to select particular number using rownum?
Example: i need only the second max number using rownum.
- 2 Answers
- 5195 Views
- Maveric, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav kumar
if you know about database then yau can simply solve this
problem .and if you don't know about database then you
can't solve this problem.then contect Mr. Gaurav kumar&
Ashwani shukla Arvind &Anshul lathi
Ph.9811303576
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / harika
select max(sal) from emp where rownum=2 group by sal
| Is This Answer Correct ? | 3 Yes | 5 No |
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.
0 Answers Capita India Pvt Ltd,
mount: mount to NFS server failed: System Error: Connection timed out
I want query to find the students name who have second highest marks in a table
what is the instrument that used in Mechanical Energy??
what is new g/l functionality
how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board
hi friends , could u please suggest the best institute in hyd or bangalore for Oracle apps and pl/sql
How to select particular number using rownum? Example: i need only the second max number using rownum.
What is sqlcode -922 & -923?
what will be the program output if it tries to access 11th item in an array of 10 and it is coded with NOSSRANGE
Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz in prod) into a temporary table(e.g abc) and then inserting into Test table(e.g xyz in prod),but not able to insert data from one db2 table to another,the error coming out is 'foreign key vaue is not valid'
Oracle Errors 
