I know this isn't quite the right group, but I also know there's a lot
of SQL programmers here.
I have a simple set of logic that I can't quite get to work.
I have a list of activities, the activity date, the group and the
What I need to do is select by group, the last activity, the date and
corresponding activitity ID for a specific activity.
In SAS my code would be something like this
proc sort data=have;
by group activity_date;
keep group activity_date activity_ID;
I just need some help translating this to SQL, please :)