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
- 15057 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / hemalatha
Following is the query to find the nth maximum salary:
select * from emp
where sal=(select distinct(sal) from emp a
where &n=(select count(sal)from emp
where sal>=a.sal;))
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to export your connection information to a file?
Write a trigger example in oracle?
What is oracle and what are its different editions?
ABOUT IDENTITY?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the difference between pre-select and pre-query?
How to connect ms access to oracle servers?
How to define an oracle cursor variable?
What are the different types of database objects?
How do I spool to a csv formatted file using sqlplus?
Does oracle database need java?
How index is implemented in oracle database?
Explain mutating triggers.
Explain the blob datatype?
can u plz provide me oca sql dumps please i need them
