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 to access db2 tables in mainframe?
What is the default page size of buffer pools?
How to create db2 table in mainframe?
What is clone table?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the difference between nvl and coalesce?
What is the difference between drop table and delete table?
What is runstats and reorg in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the function of logging in the db2 database?
What is cobol db2?
What is table space in db2?
How can you find out the # of rows updated after an update statement?
What is copy pending status in db2?
