how to check the 3rd max salary from an employee table?
- 23 Answers
- 32893 Views
- IBM, I also Faced
- E-Mail Answers
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
What is sp_helptext?
what is dbms? : Sql dba
What is the use of partition by in sql?
Where do we use pl sql?
Write a query to find the names of users that begin with "um" in sql?
what are the differences between binary and varbinary? : Sql dba
What is the purpose of my sql?
How to use boolean type in select statement?
How to assign sql query results to pl sql variables?
Is grant a ddl statement?
What is nvarchar in sql?
How do you select unique values in sql?
Is sql database free?
what is the difference between a local and a global temporary table? : Sql dba
How to order siblings in oracle hierarchy queries?
