Interested to Buy Any Domain ? << Click Here >> for more details...
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
Please Help Members By Posting Answers For Below Questions
What are the contents of dclgen?
What is the maximum size of a char data type in db2?
What do you mean by storage group (stogroup)?
What is meant by explain?
How do I optimize a query in db2?
What are iseries servers?
What is dclgen in db2?
How do we specify index to include or not during bind process.
How to test SQL -911 error while developing COB-DB2 program
What is view db2?
How do you select a row using indexes in db2?
What kind of database is db2?
What is the information associated with sysibm.syslinks table?
What is dbrm library?
Name the lockable units in DB2?
