I query it by realm

SELECT distinct UserName
FROM UsageData_OnlineHours
WHERE (UserName LIKE '[EMAIL PROTECTED]')
and sessiondate between '2004-5-01' and '2004-5-31'




Gary



----- Original Message ----- 
From: "Global Net, LLC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 10:01 AM
Subject: [Rodopi] Need Query


>
> Anyone know a query one can pull to obtain the following
>
> I need total number of distinct logins totaled per nas for a given month.
> Say in this instance (Example output)
> 7/1/2004 through 7/31/2004
> NasIPAddress        Total (Distinct Logins)
> 1.1.1.1              1000
>
>
> I tried doing this on UsageDataOnlineHours by chosing min for totals but
> something is working right, Its still giving me every login and not total
of
> distinct logins, and not sorting totals by nas
>
> Any Ideas?
>
> Jeff
>
>
>
>
> ---------------------
> To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
> with the word LEAVE as the message body.
>
> Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
> ---------------------
>





---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] 
with the word LEAVE as the message body.

Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
---------------------

Reply via email to