Hi,

I have a SQL issue I cannot figure out, perhaps somebody can help / solve / input on 
this ...

I have a table with stock-status transactions like ...

2003-06-17 06:00 stockA SKU1 QTY 98
2003-06-16 06:10 stockA SKU1 QTY 101
2003-06-15 04:59 stockA SKU1 QTY 111

- the time for updating the transaction
- each specific stock
- each specific SKU / partnumber
- quantity in stock at time of transaction

The SQL issue - are there some way in SQL I can SELECT only latest transaction for 
each stock/SKU no matter date of update, or do I have to read thrue all transactions 
and select in the program ???


Thanks and best regards
Peter Rasmussen
Copenhagen Denmark

Reply via email to