Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying the latest date on a group by query instead of the 1st
Hey guys. I have a select statement that retrieves customer activity. What I want the result to display is each active company in a specified timeframe. Currently when I do a group by on the result (so that it only shows each company once) the date value has the 1st login instead of the most...
