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
4815 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 scrollable cursor in db2?

1059

What happens in bind step in a db2 program?

978

is it compulsory commitment control in journal?

2483

How to find the number of rows in a db2 table?

1120

What is the reason behind not using select * in embedded sql programs?

1120

How to create db2 table in mainframe?

1158

How is the value function used?

1158

What are db2 tables?

1131

What is db2 instance?

1110

Explain the contention situations caused by locks?

1075

How to execute stored procedures?

1135

What is runstats db2?

1042

What is the difference between cursor and select statement?

1114

Is ibm db2 open source?

1080

What is the difference between db2 and oracle?

1135