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
- 11611 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mallikarjun
select distinct ACC.NO,
ACC. NAME,
ACC. AMOUNT
from account
where acc.name in
( select distinct acc.name
from account
group by acc.name
where count(acc.no) > 1)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What does db2 mean?
How to execute stored procedure in db2 command editor?
What do you mean by between and in? Is between inclusive of specified range values?
How will you return the number of records in table?
What is ibm db2 used for?
What is host variable in db2 cobol?
What are the contents of a dclmgen?
What is performance tuning db2?
What is the clustering index in the db2 database?
What are union and union all?
How can you count the number of rows from a table tab?
How would you find out the total number of rows in a db2 table?
What is the difference between using bind () and rebind () methods of naming class?
How to check last update on table in db2?
What does db2 blu stand for?
