how to find the fifth highest salary?
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
What is database architecture? : sql server architect
What is Data Storage - Definition Language?
How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
What is model database? : sql server architect
What does n tier mean?
Does storing of data in stored procedures increase the access time? Explain?
What are the levels of architecture?
What are the unary operations in Relational Algebra?
What is n tier architecture with example?
Define the "integrity rules"?
What is System R? What are its two major subsystems?
Illustrate physical database architecture in brief? : sql server architect
What is meant by query optimization?
What is the job of the information stored in data-dictionary?
Explain about the process which takes place to execute a stored routine?