>Can someone suggest the right parameter to pass to COUNT() function of SQL Select to accomplish the following:
>
>Table fields
>ID, C
>WEEK, N
>HRS, N
>
>

>select week, id, sum(hrs) as week_hrs, count(???) as week_cnt from
>mytable group by week, id
>

>
>I want the week_cnt in the above SQL Select to count how many records found for a given WEEK and given ID. I tried using count(*) but it gives me total of all records.
>
>I would appreciate any suggestions.

No way:

CREATE CURSOR crsTest (ID C(10), Week I, Hrs N(10,2))
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)
INSERT INTO crsTest VALUES ([ID1], 1, 12)

INSERT INTO crsTest VALUES ([ID1], 2, 12)
INSERT INTO crsTest VALUES ([ID1], 2, 12)
INSERT INTO crsTest VALUES ([ID1], 2, 12)


INSERT INTO crsTest VALUES ([ID1], 3, 12)

INSERT INTO crsTest VALUES ([ID2], 1, 12)
INSERT INTO crsTest VALUES ([ID2], 1, 12)
INSERT INTO crsTest VALUES ([ID2], 1, 12)

INSERT INTO crsTest VALUES ([ID2], 2, 12)
INSERT INTO crsTest VALUES ([ID2], 2, 12)
INSERT INTO crsTest VALUES ([ID2], 2, 12)


INSERT INTO crsTest VALUES ([ID2], 4, 12)
select week, id, sum(hrs) as week_hrs, count(*) as week_cnt from crsTest group by week, id