Find out the 3rd highest salary?
Answer Posted / shaiju nair
select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)
| Is This Answer Correct ? | 13 Yes | 25 No |
Post New Answer View All Answers
What are the set operators in sql?
What is a boolean in sql?
What is difference between sql function and stored procedure?
Why do we use joins?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is the difference between clustered and non-clustered index in sql?
Explain the insert into statements in sql?
Enlist some predefined exceptions?
What sql database should I use?
What is sql*loader and what is it used for?
How to read/write files from pl/sql?
Can you do multiple joins in sql?
Is left join and outer join same?
what happens if you no create privilege in a database? : Sql dba