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

Explain Relational Algebra in RDBMS

1128

What is data model in dbms?

958

Differentiate between nested loop, hash loop and merge join.

982

Define join and enlist its types.

1151

How to recreate the index on a firebird table?

957

What is a database in a website?

1112

What is the benefit of database?

928

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

913

What are some disadvantages of a standard language such as sql?

929

How do you maintain a database?

986

How to know the Architecture of the Database

1200

What are the different types of languages that are available in the dbms?

1076

Can I concurrently access a firebird database with embedded and with regular server?

987

What is like operator for and what are wild cards?

935

Enlist various transaction phases.

1039