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 are external procedures ? Why and when they are used?

857

What is extension and intension?

918

Which part of the RDBMS takes care of the data dictionary? How

1025

What is app tier?

872

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

729

What are the unary operations in Relational Algebra?

853

What is BCNF (Boyce-Codd Normal Form)?

876

What is a Phantom Deadlock?

994

What is a business logic layer?

801

What is an Extension of entity type?

858

What is the difference between 3 tier and 3 layer architecture?

815

What is hypermedia database?

810

Not only RDBMS takes care of locating data it also

811

Name the sub-systems of a RDBMS?

833

What is a query?

885