Sql Query for count and distinct

vinisl · New User Joined: 24 Apr 2008 Posts: 1 Location: Chennai

I want to select 3 cloumns from the table and also i want count for those distinct columns.
I dont know whether its correct/not,

select count distinct(dept,clas,item)
from table
where req=80;
Wtever req is 80 for those corresponding dept clas and items, i should count.

please help me regarding this issue.

dick scherrer · Posted: Sun May 11, 2008 5:52 am Post subject:

Hello vinisl and welcome to the forums,

Your question sounds more like a DB2 question than a JCL question. Is there some reason you posted here rather than DB2?

Your request is somewhat confusing (to me) - probably because you know exactly what you want and i do not

Please post a few sample rows/colums from your table and what you want the result of your query to be when those rows are processed. Make sure to have a combination of rows that are selected and not selected. The better your example, the better the suggestions and less questions you will receive.

Craq Giegerich