Write a query to find second highest salary of an employee.
- 27 Answers
- 23354 Views
- I also Faced
- E-Mail Answers
Answer Posted / preetir
select min(sal) from (select distinct sal from emp order by
desc where rownum < 2)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Can you select everything, but 1 or 2 fields, without writer's cramp?
The select into statement is most often used to create backup copies of tables or for archiving records?
What are schema-level triggers?
how to fetch common records from two tables? : Sql dba
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Mention what pl/sql package consists of?
How many types of cursors are available in pl/sql?
How are sql commands classified?
Does inner join remove duplicates?
How to know the last executed procedure?
What is the difference between instead of trigger and after trigger?
how to get help information from the server? : Sql dba
Is not null in sql?
What is a constraint? Tell me about its various levels.
How do you update a table in sql?
