how to find nth highest salary
Answer Posted / amarjit singh
--display 3rd higest salary in MSSQLSERVER
select max(sal) from emp
where sal <(select max(sal) from emp
where sal <(select max(sal) from emp
))
--By , STUDENT OF IET BHADDAL ENG COLLEGE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is foreign key related to primary key?
List all types of constraints in sql server?
How many replicas are maintained for each SQL Azure database?
What is the difference between function and stored procedure in sql server?
Explain trigger classes i.e. Instead of and after trigger?
What is the distinction amongst delete and truncate?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to provide default values to stored procedure parameters?
Can group functions be mixed with non-group selection fields in ms sql server?
What is set nocount on?
Define left outer join in sql server joins?
Explain differentiate between a having clause and a where clause?
What is SQL Azure?
what is the information that can be stored inside a bit column? : Sql server database administration
What is policy management?