No, It will not work. We can select DISTINCT values for multiple columns

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

will the above query work?

Question Posted / chidambara subbu

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

Answer Posted / chidambara subbu

No, It will not work. We can select DISTINCT values for
multiple columns however not all the columns will give
ditint value. For intance , see below table TABLE1
Name City
XXX Chennai
FFF HYD
XXX Blore
YYY Mumbai

1.SELECT DISTINCT NAME FROM TABLE1
Name
XXX
FFF
YYY
2. SELECT DISTINCT NAME,City FROM TABLE1
Name City
XXX Chennai
FFF HYD
XXX Blore
YYY Mumbai

See the result of second query. It has selected duplicate
entry 'XXX' in the Name column.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define data page.

1022

What is lock escalation in db2?

976

What is iseries database?

1006

What is syscat in db2?

958

What is database alias db2?

1072

What is cursor in dbms?

1015

What are the rules for db2 programming?

1046

What is check constraint. Explain with example.

1051

What is ibm db2 client?

890

What is the result of open cursor statement?

1040

How to take backup of table in db2?

1029

Comment whether the cursor is closed during commit or not.

1047

Explain the contents that are a part of dclgen.

1043

What is the use of value function?

1090

What is a system catalog table in db2?

1119