Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
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
What is the difference between postgresql and oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How to check your oracle database 10g xe installation?
Difference between varchar and varchar2 data types?
How to list all indexes in your schema?
What is a server parameter file in oracle?
What suggestions do you have to reduce the network traffic?
How many categories of data types in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
Please explain oracle data types with examples?
How to load data from external tables to regular tables?
What are the different pseudo commands? Explain in general?
What are the uses of linked server and explain it in detail?
How to create an oracle database?
Give the different types of rollback segments.