Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 38656 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 procedure function?
How do I run a pl sql program?
Can a select statement fire a trigger?
What are the two types of exceptions in pl/sql?
Explain the methods used to protect source code of pl/sql.
What is an inconsistent dependency?
Explain the structure of pl/sql in brief.
What is a common use of group by in sql?
What is the difference between database trigger and stored procedure?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Does db2 use sql?
what is sql server agent? : Sql dba
What is a subquery in sql?
what is bdb (berkeleydb)? : Sql dba
Explain normalization and what are the advantages of it?
