Find out the 3rd highest salary?
Answer Posted / himanshu
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the usage of nvl function?
What is sql scripting?
How many sql statements are used?
Is left join and outer join same?
What does rownum mean in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
What is sqlcontext?
What is informix sql?
How is data stored in sql?
What are the query optimization techniques?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
how to see the create table statement of an existing table? : Sql dba
Why do we need sharding?
Can we write ddl statements in functions?
What does pl sql stand for?