No, It will not work. SELECT DISTINCT works only for single cloumn. DI

select distinct(empid),distinct(dept),name
from EMP

will the above query work?

Question Posted / harsha

2 Answers
9147 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / harsha

No, It will not work. SELECT DISTINCT works only for single
cloumn.

DISTINCT can be applied multiple times only when you want
to apply aggregate functions such as COUNT, AVG & SUM.
e.g.
SELECT COUNT(EMPNO)/COUNT(DISTINCT(WORKDEPT)), COUNT
(DISTINCT(JOB))
FROM DSN8810.EMP

Is This Answer Correct ?

14 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2071

What is null indicator in db2?

1120

Can you use max on a char column?

1098

How to get the ddl of a table in db2?

1134

What is reorg?

1165

What are the rules for db2 programming?

1099

Which command is used to remove all rows from a table?

1119

What does runstats do in db2?

1126

What is a db2 tablespace?

1071

What does a deadlock mean in DB2?

1170

What is db2 plan table?

1054

What is a bind card?

1225

define clustering index.

1036

Can we update view in db2?

1007

How can you do the explain of a dynamic sql statement?

1073