Let's say I have a table called DOWNTIME. Fields let's say are: LINE_NUM, SHIFT, REASON, DATECODE, PRODUCT, OPERATOR, FLAG1, FLAG2, FLAG3, NOTES, DOWNTIME
This table has 1000's of records accumulating DOWNTIME minutes of 12 separate production lines (LINE_NUM = 1,2,3,...12).
I want to return a 12 line recordset.
Each of the 12 records should be the record where the most recent DATECODE is found (per LINE_NUM).
I need *all of the fields* displayed for that one record. (not just one or two fields using max(), group by clause)