Yes, we can use the Group-by in the subquery. -----EX---- SELECT DISTINC

Can we use group-by clause in sub-query? If 'yes'
means,Will it be executed successfully or else If 'no'
means why should we not using that method? Give me your
suggestion please....

Question Posted / db2222

1 Answers
4797 Views
I also Faced
E-Mail Answers

Answer Posted / db2222

Yes, we can use the Group-by in the subquery.
-----EX----
SELECT DISTINCT(A.IDN), B.NAME,B.EFF_DATE, B.CNCRCY_TMSTMP
FROM
Table1 A,
Table2 B,
Table3 C
WHERE
A.IDN = C.IDN
AND C.IDN = B.ALIAS_IDN
AND A.IDN IN
(SELECT IDN
FROM Table4
GROUP BY CUSACC_IDN
HAVING COUNT(*) > 1
)
WITH UR;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is diffrence b/w file-aid tool and file-aid utility???

4886

What kind of database is db2?

1030

List out the data types available.

1145

List down the types of triggers in the db2 database?

1018

How to compare data between two tables in db2?

1078

Which isolation level provides maximum concurrency?

1150

What is universal database?

1066

What does db2 stand for?

1014

Is it possible using max on a char column?

1134

Is db2 relational database?

971

What is cursor in dbms?

1055

Can we delete records from view?

962

What does sqlcabc has?

1044

How do I add a column in db2?

1041

What are iseries servers?

1068