There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 15139 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nagireddy
select max(sal) from emp a where 5=(select count(distinct sal)
from emp b where a.sal<=b.sal);
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is null indicator in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What are packages in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
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.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are the benefits of using the db2 database?
What do you mean by storage group (stogroup)?
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 .....
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Explain packages.
What is the use of commit in db2?
What is load replace in db2?
