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 the syntax for creating a table in the db2 database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How would the varchar column remarks defined?
Explain db2.
What is the difference between dbm cfg and db cfg file in db2 ?
Explain packages.
What os does db2 run on?
What is consistency token in db2?
How can record locking be achieved in those DB2 versions which do not support it?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is db2 and what is the use of db2 optimizer?
What is cascading rollback?
What is catalog database in db2?
Is it possible using max on a char column?
How is a typical db2 batch pgm executed?
