Interested to Buy Any Domain ? << Click Here >> for more details...
There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 17789 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajib
select max(salary) from staff where salary not in(select
salary from staff order by salary desc fetch first 4 rows
only)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is runstats utility in db2?
How do I add a column to a table in db2?
What parameters are used to control the free space in DB2?
What is db2 connect?
What is the cobol picture clause of the db2 data types date, time, timestamp?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
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.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the difference between bind and rebind in db2?
What is package in cobol db2?
Why db2 is called db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is ibm db2 used for?
What is a db2 schema?
How to check sequence on a table in db2?
