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

select Nth highest salary by using rownum

Question Posted / welcomeashwin

4 Answers
21777 Views
Ford, TCS, Tech Mahindra, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which database server is best?

1082

What are the components of rdbms?

940

Explain the different types of join operations?

1047

What is the purpose of a database table?

946

What is structure of dbms?

920

Explain the advantages of rdbms?

936

What are the different types of database keys?

1034

What do you understand by cursor? Mention the different types of cursor?

1059

how to retrive a data From database into the grid view..?

884

What is cold backup and hot backup (in case of oracle)?

911

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

2107

What is netlib for clipper?

899

Explain data independence?

1042

What are the main functions of a database management system?

941

In which format image is stored in database?

897