SQL problem

I'd like to adapt the following select-statement so I keep just the first row after each break on tank/phase

select tank,phase,stock from e_workord order by tank,phase,date desc,workord

The table e_workord has the following fields : workord,phase,date,tank,stock.
Can this be done with just SQL (by means of correlated subqueries)?

Thanks,

Johan Verlinden Received on Thu Oct 19 2000 - 03:18:08 CDT