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
- 17653 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / payel
SELECT * FROM STAFF AA
WHERE 5 = (SELECT COUNT (SALARY) FROM STAFF WHERE SALARY
<= AA.SALARY );
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is drop table?
What is the difference between cursor and select statement?
How does coalesce work?
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?
How to check sequence on a table in db2?
How do I delete a column in db2?
How can we retrieve the total number of records in RPG & CLLE?
Is it possible using max on a char column?
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.
Explain the function done by data manager?
Explain the contents that are a part of dclgen.
What do you mean by storage group (stogroup)?
How to check last update on table in db2?
How to execute stored procedure in db2 command editor?
Why do we bind in db2?
