The situation is somewhat hard to describe, so please bare with me:
I am trying to group my results by the last activity on each row, my query
looks like this
select text, dt, item_id from table
group by item_id
order by dt DESC
here is an example record set.
the results from the above query would be:
my problem is that i want the other item to show up. the item with the most
recent DT. it is doing the grouping before it does the ordering. how do i
specify that I want to see the most recent info when it does the group?
thanks in advance.