Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sivaraman
select * from table1 a where n = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)
n is value of n it should be numeric....
| Is This Answer Correct ? | 15 Yes | 15 No |
Post New Answer View All Answers
How can you count the number of rows from a table tab?
What is role in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to fetch the last row from the table in SQL (db2)?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is a bind in db2?
How do you stop a db2 database in linux?
What is page size in db2?
What do you mean by storage group (stogroup)?
What is the use of db2?
How do I add a column to a table in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to find the number of rows in a db2 table?
What is package in cobol db2?
What do you mean by rollback?
