Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37875 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 are the benefits of stored procedures?
What is the main reason behind using an index?
What is sql mysql pl sql oracle?
What is indexing oracle sql?
What is difference between function and trigger?
what are date and time data types? : Sql dba
What are % type and % rowtype?
Why do we use procedures?
what are the drivers in mysql? : Sql dba
Is merge a dml statement?
How do I run a sql query in pgadmin 4?
what are local and global variables and their differences? : Sql dba
How do I partition a table in sql?
Define commit?
What is right join in sql?
