how to check the 3rd max salary from an employee table?
- 23 Answers
- 29761 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / b.v.siva kumar
Use this for SQL Server:
select top 1 salary from emp where salary in (select
distinct top 3 salary from emp order by salary desc) order
by salary
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is view explain with example?
How do I start sql from command line?
What is function and procedure?
Can we use insert statement in function?
What are some emotional triggers?
what are the different tables present in mysql? : Sql dba
What is difference between stored procedure and trigger?
what is sub-query? : Transact sql
What are stored procedures in mysql?
What is trigger explain it?
What is the max nvarchar size?
What are the types of variables use in pl sql?
What is the use of & in pl sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
What are the subsets of sql?
