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 VDL (View Definition Language)?

749

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

586

What is the difference between cube operator and roll up operator? : sql server architect

549

What is extension and intension?

622

What is E-R model?

592

What is Record-at-a-time?

549

When is a functional dependency F said to be minimal?

530

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

555

What is Data Model?

625

Describe the three levels of data abstraction?

603

Explain what are the database objects? : sql server architect

527

Do you know what the restrictions applicable while creating views are? : sql server architect

515

What is Lossless join property?

691

What is difference between two tier and three tier?

488

What is one tier architecture?

510