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

8 Answers
12424 Views
IBM, Infosys, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1483

Explain about the implementation of stored procedures?

821

What is Functional Dependency?

753

How do you communicate with an RDBMS?

856

What is a Relation Schema and a Relation?

849

Why fastload support to empty table?

1631

What is external database?

811

What do you mean by flat file database?

856

What is app tier?

801

What do you mean by atomicity and aggregation?

823

What is "transparent DBMS"?

813

Where the procedures are stored in database?

795

Brief theory of Network, Hierarchical schemas and their properties

781

What is DDL (Data Definition Language)?

826

Explain logical database components? : sql server architect

710