how to check the 3rd max salary from an employee table?
Answer Posted / dulal
Without Using MAX or MIN keyword
select TOP 1 EmpName, RevisedMinutes
from tblEncounter
where RevisedMinutes IN(select distinct Top 3
RevisedMinutes from tblEncounter order by RevisedMinutes
desc)
order by RevisedMinutes asc
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can you have more than one key in a database?
How many times can we commit in a loop?
Is sql injection illegal?
How does a self join work?
Can instead of triggers be used to fire once for each statement on a view?
What is sql rowcount?
what are the 'mysql' command line options? : Sql dba
What are the uses of merge?
How do I add a database to sql?
what are the t string functions available in tsql? : Transact sql
What is clustered index in sql?
Is foreign key mandatory?
What is t sql in sql server?
What is a primary key? Explain
How does sql store data?