Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 36964 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
Define commit, rollback and savepoint?
what are date and time functions in mysql? : Sql dba
how to get a list of all tables in a database? : Sql dba
What is trigger price?
What is data abstraction in sql?
What are all different types of collation sensitivity?
Why use truncate instead of delete?
how do you tune the slow running queries in oracle db , explain the methodology
What is the difference between the conventional and direct path loader? : aql loader
What are the different ddl commands in sql?
What are sql indexes?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
is mysql query is case sensitive? : Sql dba
Do stored procedures prevent sql injection?
What is user defined functions?
