Interested to Buy Any Domain ? << Click Here >> for more details...
if suppose i am having an ACCOUNT table with 3 coloumns ACC.
NO,ACC. NAME,ACC. AMOUNT . If a unique index is also
defined on ACC.NO and ACC.NAME then write a query to
retrieve account holders records who have more than 1 ACC.
- 8 Answers
- 11952 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anandrao
please try this solution also
select count(*),ACC.NO
FROM ACCOUNT
group by ACC.NO
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is db2 and what is the use of db2 optimizer?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Define db2 and its databases?
B37 abend during spufi?
How do I delete a table in db2?
How can you count the number of rows from a table tab?
What do you mean by rollback?
Can there be more than one cursor open for any program?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is a db2 cursor?
What is null value in db2?
Can you use 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.
If I have a view which is a join of two or more tables, can this view be updateable?
What is the usage of open cursor command?
