Re: help with query to get last row

> Certainly, as it's a basic group by query:
>
> select order_no, status, status_date
> from t_orders
> where status_date in
> (select max(status_date) from t_orders group by order_no)
>
>
> ORDER_NO STATUS STATUS_DA
> ---------- ---------- ---------
> 1223 Closed 01-MAR-05
> 2138 InWork 01-SEP-05
>
>
>
> David Fitzjarrell

Thanks David! Received on Thu Jan 26 2006 - 08:20:50 CST