Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32258 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / tauseef
select last_name,salary from(
select last_name,salary ,rownum rk from(
select distinct salary,last_name from employees order by
salary desc nulls last))
where rk=9
By this way u can find 2nd,3rd n nth highest salary wit the
name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I copy a table in sql?
What do you understand by pl/sql records?
How can you know that statistics should be updated?
what is the difference between a having clause and a where clause? : Sql dba
Can %notfound return null after a fetch?
What are pl/sql cursor exceptions?
How do you create a db file?
How delete a row in sql?
Difference between truncate, delete and drop commands?
How is a process of pl/sql compiled?
Explain dml and ddl?
Why do we create views in sql?
Can we connect to postgresql using sql developer?
What is lexical units in pl sql?
How to write html code in pl sql?
