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
- 15440 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
Explain what are the different type of segments?
How can we find out the current date and time in oracle?
How to turn on or off recycle bin for the session?
How to drop a stored procedure in oracle?
What is Reduced List of Values?
What are the various types of snapshots ?
What is a sub query and what are the different types of subqueries?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Can we commit inside a function in oracle?
How to resolve name conflicts between variables and columns?
Give the advantages and disadvantages of clusters.
Is it possible to insert comments into sql statements return in the data model editor ?
What are the different types of partitions in oracle?
How to define an external table with a text file?
Explain drop constraint oracle?
