SELECT TOP 4
MemberName,
(
SELECT
Count(MemberID)
FROM
Logins
WHERE
DateTimeLogin BETWEEN some_date AND getDate()
GROUP BY
MemberID
ORDER BY
Count(MemberID) DESC
)
AS TotalLogins
FROM
Members
WHERE
MemberActive = 1
ORDER BY
TotalLogins DESC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
