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
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is db2 look?
How to create db2 table in mainframe?
What are the two types of logging in the db2 database? Explain them.
What is copy pending and check pending in db2?
How can the duplicate values be eliminated from db2 select?
What is cascading rollback?
Mention data types used in db2 ?
What is buffer pool?
How can you do the explain of a dynamic sql statement?
How to create backup table in db2?
How does db2 sample database connect?
When reorg is used?
What is the difference between oracle and db2?
What language is db2 written in?