Hi All,
Is there a way to implement the below logic without using ROW_NUMBER () OVER feature that Oracle provides ?
SELECT
cost_object INTO out_cost_object
FROM
(
SELECT equip_no,
cost_object,
ROW_NUMBER () OVER (PARTITION BY equip_no, trunc(in_date)
ORDER BY start_date) row_number
FROM escost_object_assign
WHERE equip_no = in_equip
AND in_date between start_date and nvl(end_date,sysdate)
)
WHERE
a. row_number = 1 ;
I want to implement this logic in one of the tool which does not support ROW_NUMBER OVER feature. Please let em know if you need any info.
Thanks and Regards
Nagaraja Akkivalli.