netlink
Дата: 15.03.2011 18:29:00
select first_value(date_create) over (partition by date_work order by date_create desc) Last_Date_Create,
last_value(date_create) over (partition by date_work order by date_create ) Last_Date_Create_last
,row_number() over (partition by date_work order by date_create ) Last_Date_Create_RN
from
(
select sysdate-3 as Date_Create, trunc(sysdate) date_work from dual
union all
select sysdate-2 as Date_Create, trunc(sysdate) date_work from dual
union all
select sysdate-1 as Date_Create, trunc(sysdate) date_work from dual
)
Выполняю данный селект... и вместо того, чтобы увидеть два одинаковых столбца вижу разные значения
1 14.03.2011 18:27:18 12.03.2011 18:27:18 1
2 14.03.2011 18:27:18 13.03.2011 18:27:18 2
3 14.03.2011 18:27:18 14.03.2011 18:27:18 3