Answer Posted / asp
select * from table1 a where (n-1) = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What is sqlca?
Define data page.
Which isolation level provides highest data integrity?
What is alias in db2?
How is the value function used?
What is the difference between using bind () and rebind () methods of naming class?
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 a page in db2?
What is ibm db2 connect?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is copy pending status in db2?
What is runstats and reorg in db2?
What is runstats db2?
How does a cursor work?
List some fields from sqlca?