SELECT * FROM HR.EMPLOYEES EMP1 WHERE &N=( SELECT COUNT(DI

select Nth highest salary by using rownum

Question Posted / welcomeashwin

Answer Posted / welcomeashwin

SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of database software?

504

what do u mean by implementation?

1588

Is file system a database?

477

How to use events with zebedee, ssh or stunnel?

538

What is the best database software?

506

What are the types of rdbms?

493

What's the difference between clustered and non-clustered indexes?

486

Enlist various types of interactions created by dbms?

494

Explain what are triggers and rules?

512

What are the differences between drop, truncate and delete commands?

548

What is the use of drop command?

743

Why is data modelling important?

455

Which is best database?

491

What are indexes? Mention the differences between the clustered and non-clustered index?

511

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1478