October 30th, 2013, 05:42 PM
Last transaction query
I have a table with three fields, for all intents and purposes:
There can be multiple xactions per item.
I need a SQL that will give me the LAST transaction for each item.
Now, if I am looking for ONE item, that is simple. But I need this for ALL items... basically I want the item, with the last xaction and the date time of that last transaction.
October 31st, 2013, 11:22 AM
FROM ( SELECT Item
, MAX(XActionDateTime) AS latest
BY Item ) AS m
JOIN ThreeFieldTable AS t
ON t.Item = m.Item
AND t.XActionDateTime = m.latest