Answer Posted / bhaskar reddy
select * from table1 a where(n-1)= (select count(distinct
sal) from table1 b where b.sal>a.sal)
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is db2 catalog database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dclgen (declaration generator)?
Which are the db2 tools to protect integrity of the database?
What is deadlock in db2?
How does a cursor work?
what is the responsibility of the construction superintendent
List some fields from sqlca?
Is schema the same as database?
What is the use of predicate?
Explain about rct.
How can we read records for specific member in CL? AND rpg?
What is a db2 collection?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is temporal table in db2?