Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15701 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / samad
Dear
here i am sending new ans u can give the value in parameter
SELECT SAL,NO FROM(
SELECT SAL ,ROWNUM NO FROM
(SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC)) WHERE NO=:N
Regards,
Samad
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What does sharding mean?
What is a dead lock in oracle?
What is PL/SQL ?
What is integrity and what is constraint??Explain with example
How to use "for" statements in oracle?
What are privileges and grants?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Why is oracle database so popular?
What is a tns file?
Why oracle is used?
Why is oracle used?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Why packages are used in oracle?
What is a nvl function?
