MAX VALUE FROM SINGLE SELECT
Hi All,
create table T1
(e_sal number,
s_dt date);
I want e_sal of max date from the table.
I have written like this < SELECT E_SAL FROM T1 WHERE S_DT = (SELECT MAX(S_DT) FROM T1);
Here I have to write 2 select statement from same table. But how can I get same result through single select statement?
PLS. HELP ME.
REGARDS,
JIMUT