How to get Top 10 Salaries from a Table
Answer Posted / regu
select distinct salary from table name hwre rownum <=10
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is bind package and plan in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What r the comman abends in db2, jcl and cobol???????
What is db2 purescale?
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 rct?
Are view updateable?
How would the varchar column remarks defined?
Explain the benefits you can get from mainframe connect?
How and when does the db2 enforces the unique key?
What kind of database is db2?
What are union and union all?
What is difference between isnull and coalesce?
How to find the number of rows in a db2 table?
What do you mean by cursor?