Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 31177 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
What is sp_helptext?
How do I view a sql database?
How many tables can a sql database have?
What does closing a cursor do?
What does where 1 1 mean in sql?
how to select unique records from a table? : Sql dba
What does truncate mean in sql?
What is a Mapplet?
Does mysql_real_escape_string prevent sql injection?
What is difference between nchar and nvarchar?
Is big data nosql?
Is sql workbench free?
How is indexing done in search engines?
Is id a reserved word in sql?
what is a database lock ? : Sql dba
