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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Are views updateable?
Who uses db2?
How to connect to db2 database from windows command line?
Name the lockable units in DB2?
How to check sequence on a table in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What are the two types of logging in the db2 database? Explain them.
How to check table size in db2 sap?
What is the advantage in De-normalizing tables in DB2?
Mention some fields that are a part of sqlca.
What is db2 bind process?
How do you pull up a query which was previously saved in qmf?
What is db2 optimizer?
