Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 28472 Views
- Accenture, HTC, I also Faced
- E-Mail Answers
Answer Posted / bharath
In Oracle,
select e1.* from emp e1
where &n>(select distinct(COUNT(*)) from emp e2
where e1.sal>e2.sal)order by sal;
Place where n=10
we get,
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Name the lockable units in DB2?
How to access db2 tables in mainframe?
define clustering index.
What is the max length of sqlca?
What is db2 optimizer?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is consistency token in db2?
Explain about dbrm.
What are host variables in db2?
What is schema in db2?
What is dbrm in db2 database?
What is the physical storage length of date data type?
How do I delete a column in db2?
What kind of database is db2?
What is cursor in dbms?
