Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 38666 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 'mysqlcheck'? : Sql dba
Can you join views in sql?
how to enter binary numbers in sql statements? : Sql dba
How many scalar data types are supported in pl/sql?
What is compiled query?
Why do we create views in sql?
List different type of expressions with the example.
What is an emotional trigger?
Can we perform dml on view?
What is a join query?
What is having clause in sql?
Compare sql & pl/sql
What is before trigger?
how do you know the version of your mysql server? : Sql dba
What is sql and also describe types of sql statements?
