1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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.

Question Posted / mainframe.rahulz

Answers were Sorted based on User's Feedback



if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

Answer / lol

select ACC.NO||ACC.Name from ACCOUNT having count(acc.no||acc.name) >1

Is This Answer Correct ?    0 Yes 0 No

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

Answer / ratheesh nellikkal

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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a uniqu..

Answer / 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

More DB2 Interview Questions

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1 Answers  

difference between group clause and order clause

1 Answers  

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

What is the difference between spufi and qmf?

1 Answers  

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

What is bind plan?

1 Answers  

What is the function of the Data Manager?

2 Answers  

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

1 Answers  

Which command is used to connect to a database in DB2 ? Give the Syntax.

1 Answers   MCN Solutions,

Can any one tell me about Restart logic in DB2.

2 Answers  

For more DB2 Interview Questions Click Here
Categories