Hi, Use this query... select id ,ord_num, ord_Date from where ord_num = (select max(ord_num) from where ord_Date =(select max(ord_Date) from )) :)

Hi, you can use this query ... however you can reduce the no. of DML stm.. SELECT dem.first INTO abc FROM (SELECT SUM(t) AS first FROM demand WHERE product = 'LPG' AND LOCATION = 'Mumbai' ) dem