need help to optimize query

[tamilselvan]

Use the following SQL.
I changed <> to > and <.
This uses index.

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