write a query for the fifth highest salary?
Answer Posted / venkates
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
what are wrappers and build ups and what it's use?
When should you not use firebase?
Data structure used to implements a menu:
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
what is the role of auditor in auditing data oriented applications?
What is the difference between data source and database?
Explain database partitioning. What is its importance?
Explain entity type?
How to do performance tunning a database in DB2 V8.2 UDB in linux
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What is a Database?
What is Object Oriented model?
Is it good to store images in database?
What is lagging in DBMS ?