count function 1

[georgia51390]

Hi there, I have a table that has one column of ID #s. The ID's represent people and can be in the table any number of times. I have a second column of dates - these are dates that the ID/person was active in the system. For each unique ID, I need to count how many times were they active (how many dates they have)? Any suggestions?

 

[redlam]

something like this might work:

select ID,
count(active_date)
from table1
group by ID

 

[georgia51390]

thank you!! It worked perfectly!!