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
- 9907 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suleman
Try this one
select ACC.NO,ACC.NAME
FROM ACCOUNT
group by ACC.NO
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is db2 plan table?
Which component is responsible for processing sql statements and selecting access paths?
How do I delete a column in db2?
What is explain plan in db2?
Which component is responsible for db2 startup and shutdown?
How to create db2 table in mainframe?
What is cursor with hold option in db2?
How to find the number of rows in db2 tables?
Is db2 a mainframe database?
Define db2 and its databases?
How do I change the column size in db2?
Mention data types used in db2 ?
How to access db2 tables in mainframe?
What are the contents of a dclmgen?
Are views updateable?
