Find out the 3rd highest salary?
Answer Posted / vikram kumar
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
How much does a sql dba make? : SQL DBA
What does pl sql stand for?
What is lookup table in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
what are different types of keys in sql?
What is a parameter query?
What is application trigger?
How can triggers be used for the table auditing?
What is pl sql code?
How many clustered indexes can be created on a table?
What information is needed to connect sql*plus an oracle server?
What will you get by the cursor attribute sql%notfound?
How is data stored on a disk?
Is join same as left join?