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


Please Help Members By Posting Answers For Below Questions

What is database architecture? : sql server architect

468


What is Data Storage - Definition Language?

462


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

451


What is model database? : sql server architect

444


What does n tier mean?

397






Does storing of data in stored procedures increase the access time? Explain?

790


What are the levels of architecture?

437


What are the unary operations in Relational Algebra?

474


What is n tier architecture with example?

412


Define the "integrity rules"?

466


What is System R? What are its two major subsystems?

430


Illustrate physical database architecture in brief? : sql server architect

427


What is meant by query optimization?

505


What is the job of the information stored in data-dictionary?

474


Explain about the process which takes place to execute a stored routine?

422