Hi-
I'm trying to analyze some information in my LinksSQL ClickTrack table, and wonder if there is an SQL command that will find the number of unique IP addresses for a give time period. So, it would be something like:
SELECT IP (Unique Somehow?)
FROM ClickTrack
WHERE Created > '20030401000000'
and Created < '2030402000000'
Does anyone know if there is an SQL command that will find the total number of Unique instances of a column value?
-Frank
I'm trying to analyze some information in my LinksSQL ClickTrack table, and wonder if there is an SQL command that will find the number of unique IP addresses for a give time period. So, it would be something like:
SELECT IP (Unique Somehow?)
FROM ClickTrack
WHERE Created > '20030401000000'
and Created < '2030402000000'
Does anyone know if there is an SQL command that will find the total number of Unique instances of a column value?
-Frank