SELECT MIN(SAL) FROM(SELECT TOP 5 * FROM EMP ORDER BY SAL DESC) AS MIN

how to find the fifth highest salary?

Question Posted / srinu

Answer Posted / srinu

SELECT MIN(SAL) FROM(SELECT TOP 5 * FROM EMP ORDER BY SAL
DESC) AS MIN_SAL

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is an Extension of entity type?

885

What is the job of the information stored in data-dictionary?

851

What is RDBMS KERNEL?

1128

What is "transparent DBMS"?

910

What is DDL (Data Definition Language)?

931

What does n tier mean?

783

What are the three levels of database architecture?

784

What is 2 tier 3 tier architecture?

895

What is Relational Algebra?

938

What is the difference between stored procedures and stored functions in oracle?

1007

What is Lossless join property?

1015

What is master database? : sql server architect

938

What is 4NF?

957

What is a view? How it is related to data independence?

970

What is n tier architecture with example?

812