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

Illustrate physical database architecture in brief? : sql server architect

765

What is master database? : sql server architect

881

What is DDL (Data Definition Language)?

884

What is meant by query optimization?

860

What is Data Storage - Definition Language?

887

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus

787

What is RDBMS KERNEL?

1088

What is temp db database? : sql server architect

889

What is system catalog or catalog relation? How is better known as?

848

Explain the microsoft sql server delete command? : sql server architect

806

What is raid and what are different types of raid configurations? : sql server architect

920

What is single tier architecture?

803

What is parallel database architecture?

841

What is database architecture? : sql server architect

891

What is end user data?

809