write a query for the fifth highest salary?
Answer Posted / suparna
select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)
Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
What are different types of blocks used in stored procedure?
Why merge statement is used inside the database?
What are the advantages of normalizing a database.
Which is the best graph database?
Write a query to get maximum and second maximum in oracle?
how can we view column head in first page but not in remaining pages?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is the difference between primary key, foreign key and candidate key?
Explain phantom deadlock?
what is the role of auditor in auditing data oriented applications?
Define stored procedure?
What is lagging in DBMS ?
Explain the record term used in database.
List various types of log-based recovery in DBMS.