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

Describe why operational and informational systems are separate.

939

What is a concurrency problem in dbms?

975

Is there an example how to configure externalfileaccess setting in firebird.conf?

956

What is the largest component of a database?

1294

What is the concept of sub-query in terms of sql?

959

Explain what are called fat clients and fat servers?

1063

What is the relationship?

976

What is 1nf?

960

What do you mean by aggregate and scalar functions in dbms?

931

Explain the Normalized Relations?

2695

What is data model in dbms?

910

What is a table called in database?

978

Explain the Surrogate Key in DBMS.

951

What are the benefits of database management system?

1026

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

935