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
Does storing of data in stored procedures increase the access time? Explain?
What is Relational Calculus?
What is DDL Interpreter?
Explain about recursive stored procedures?
What are the three levels of database architecture?
What is DML (Data Manipulation Language)?
What is a two tier wage system?
What do you mean by Correlated subquery?
What is Fully Functional dependency?
What is a checkpoint and When does it occur?
What is difference between two tier and three tier?
Which is super key?
What is temp db database? : sql server architect
What is single tier architecture?
Define the "integrity rules"?