Find out the 3rd highest salary?
- 51 Answers
- 66534 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar
SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Are subqueries better than joins?
what are string data types? : Sql dba
Which join is like inner join?
What is the difference between microsoft access and sql?
How to start oracle sql developer?
What is coalesce sql?
How do you modify a table in sql?
how to fetch common records from two tables? : Sql dba
How many functions are there in sql?
What are conditional predicates?
What are the different dcl commands in sql?
how many columns can be used for creating index? : Sql dba
What are sql indexes?
Explain exception handling in pl/sql?
How can we store rows in PL/SQL using array?
