SELECT * FROM EMP WHERE N=(SELECT COUNT(DISTINCT SAL) FROM EMP WHERE SAL&g

select Nth highest salary by using rownum

Question Posted / xxx

Answer Posted / xxx

SELECT * FROM EMP WHERE N=(SELECT COUNT(DISTINCT SAL) FROM EMP
WHERE SAL>=e.SAL);

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

852

How to prevent concurrent access to my data?

1036

How to use events with zebedee, ssh or stunnel?

926

Why is normalisation used?

926

What is the diff bet plan,package,dbrm?

1108

How do you notify dbpak about stored procedure?

923

How does notification services work?

932

How do we select distinct values from a table?

930

What are the characteristics of data in the database?

984

Explain armstrong rules? How they are complete and/or sound?

905

What is dbms_output put_line?

912

What is query in database?

928

Which two can be implemented as a centrally located logical architecture?

924

Explain meant by 3-tier architecture?

950

What methods is used to commit the changes made in DataSet object?

1063