Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7495 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ritesh
select max(salary) from emptable where salary < (select max(salary) from emptable);
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vijayalakshmi
select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name
| Is This Answer Correct ? | 4 Yes | 0 No |
select a.last_name,a.salary from employees a where 3=(select count(*) from employees b where b.salary>a.salary) order by a.salary desc.
<<<<<<<<<[N-1]>>>>>>>>>>
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santosh kumar
select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
What to do if the startbd.bat failed to start the xe instance?
How to use like conditions in oracle?
What is Partitions in Table ?
Explain an exception and its types?
How to get execution statistics reports on query statements?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
From the database level, how can you tell under which time zone a database is operating?
What is an external table?
What is a database table in oracle?
What is the fastest query method to fetch data from the table?
What are cursor?where are they used?
candidate key is subset of super key but not vice-verse explain
Oracle General 
