Hi,
I'm puzzled..perhaps someone can shine a little light on my stupidity...
I'm trying to retrieve a log from a table,
and only get distinct IPAddress-es, but no restriction on other fields.
this is my SQL string sofar.. and I'm not sure what I'm wrong on.
SELECT DISTINCT IPAddress, LogID, Domain, Browser, WebAddress, PageLoaded, Parameters, DateCreated FROM tblLogs ORDER BY DateCreated DESC
It lists everything, just as if I didn't have the DISTINCT in there.
Also, I'd like to restrict it to TOP 100.. and I just got errors with that for some reason.
thanks,
-Peter
I'm puzzled..perhaps someone can shine a little light on my stupidity...
I'm trying to retrieve a log from a table,
and only get distinct IPAddress-es, but no restriction on other fields.
this is my SQL string sofar.. and I'm not sure what I'm wrong on.
SELECT DISTINCT IPAddress, LogID, Domain, Browser, WebAddress, PageLoaded, Parameters, DateCreated FROM tblLogs ORDER BY DateCreated DESC
It lists everything, just as if I didn't have the DISTINCT in there.
Also, I'd like to restrict it to TOP 100.. and I just got errors with that for some reason.
thanks,
-Peter