I am attempting to figure out how to count the number os distinct rows
in a table.
I have tablex with columns DATEIN and SESSIONID where SESSIONID can
have multiple entries for the same SESSIONID.
I only want the row count between two dates in DATEIN ( not a problme)
AND not include any duplicates of SESSIONID.
I have tried -
SELECT DISTINCT COUNT(SESSIONID) as xRows FROM Tablex
WHERE DATEIN BETWEEN '8/14/2003 00:00:00 AM' and '8/14/2003 11:59:59
GROUP BY SESSIONID
And I get a row for each SESSIONID. All I want is the total row count
for the date ...