SELECT t.* FROM (
SELECT ROW_NUMBER() OVER(ORDER BY f.flight_dep) AS rownum,
fs.flight_sche_seq as flightScheSeq,
(select sum(i.price) as dd from ka_flight_itinerary i, ka_flight_booking fb
where i.flight_sche_seq = fs.flight_sche_seq
and fb.booking_status = 'N'
and i.flight_booking_seq = fb.flight_booking_seq) as sumPrice
FROM ka_flight f, ka_flight_sche fs
WHERE fs.flight_no = f.flight_no
and fs.flight_date between '2015-01-30' and '2015-01-31'
) as t
order by rownum asc