Hi,

I am writing a query as


select * from test
where trade_date = (select max(trade_date) from test where trade_date <> trunc(sysdate));

where I want the record having the max trade_date and which is not todays date.

The data in the table looks something like this

TRADE_DAT SHARES
--------- ----------
22-SEP-02 200
21-SEP-02 300
20-SEP-02 400
24-SEP-02 100

is there a better way of writing this query.

Thanks