Write a query to find second highest salary of an employee.
- 27 Answers
- 24352 Views
- I also Faced
- E-Mail Answers
Answer Posted / senorita
select ename,salary from (select rownum,ename,salary from
emp
order by desc) where rownum=2;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a boolean in sql?
Does sql backup shrink transaction log?
What does := mean in pl sql?
What is cte?
what is not null constraint? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
What are the two characteristics of a primary key?
what are the type of locks ? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
How do I order columns in sql?
Which are sql * plus commands?
What do you mean by rowid?
What are the types of functions in sql?
How many developers work on postgresql?
How do I partition a table in sql?
