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 MEANT BY COMMIT COMMAND?
db2 restart logic ?
what is db2 restart?
What is check constraint in db2?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What is difference between alias and synonym in db2?
What is index in db2?
what is different three logs in DB2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is bind and rebind in db2?
What is the syntax for creating a table in the db2 database?