To get just a count grouped by NAS, try the following select nasipaddress, count(distinct username) from usagedata_onlinehours where sessiondate between '7/1/04' and '7/31/04' group by nasipaddress
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gary Carr Sent: Tuesday, August 03, 2004 9:13 AM To: [EMAIL PROTECTED] Subject: [Rodopi] Need Query 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 --------------------- --------------------- 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 ---------------------
