Interested to Buy Any Domain ? << Click Here >> for more details...
select distinct(empid),distinct(dept),name
from EMP
will the above query work?
- 2 Answers
- 9122 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Define db2 and its databases?
What is meant by a unit of recovery?
What does the CHECK Utility do ?
How will fetch last 5 rows from table in db2
How is a typical DB2 batch program executed ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is ALTER ?
What is the use of runstats in db2?
What is db2? Explain.
Can we install 2 different versions of Db2 on same mainframe?
COBOL 
