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 gkittelson 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
Completely forgot to use max() in front of the date! Now its the most recent login but it is sorting by company (i assume thats from the group by) and not by date... -
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...
