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.
Answers were Sorted based on User's Feedback
Answer / ram prajapati
sir,
is it possible to have duplicate values for a uniquely
defined column.........or ... is it possible to define a
unique index on a column which is not having unique value?
plz help me out..
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / s
For this scenario duplicate records will not exist in the
table as the index has been defined on the 2 primary keys.
Hence the answer is we can't pull the account holders
having more than 1 account
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / lol
select ACC.NO||ACC.Name from ACCOUNT having count(acc.no||acc.name) >1
Is This Answer Correct ? | 0 Yes | 0 No |
Hi All,
Here u already have a unique index defined on ACC.NO and ACC.NAME feilds.
Unique index will not allow more than one value for this particular field (Correct me if I am wrong).
Then hw can we get more that one a/c no for a person in this scenario ?
So the answer will be, u can not store more than one a/c number for a person since u have a unique indexes on these table.
Regards,
Ratheesh Nellikal
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rihaan
Thanks a lot Mr.Mallikarjun but the inner query u wrote
alone does the work.
kindly check it up
Is This Answer Correct ? | 0 Yes | 2 No |
what is the role of the cursor in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
where can we use index and subscript ? with example ?
What is a db2 package?
What is pagespace?
What does db2 plan contain?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
how to copy the host variables from ps file into cobol program other than include statement
How do I change the column size in db2?
Define buffer pool.
Explain about dbrm.
What is a DB2 catalog?