[SOLVED] Select unique records by date

[powelly]

I have the following data recording visitors to a site.

 

DATE IPADDRESS

01/01/2007,192.168.1.1

01/01/2007,192.168.1.2

10/01/2007,192.168.1.1

10/01/2007,192.168.1.2

10/01/2007,192.168.1.3

11/01/2007,192.168.1.1

 

I want to select the number of unique ipaddresses per date and return something like this

 

Date,UniqueIPs

01/01/2007,2

10/01/2007,3

11/01/2007,1

 

Could someone be kind enough to point me in the right direction?

[kirk112]

Something like this?

 

SELECT COUNT(IPADDRESS) AS UniqueIPs, DATE

FROM table_name

GROUP BY IPADDRESS, DATE

ORDER BY DATE 

 

 

[powelly]

Perfect Thank you