ORACLE WITH 语句 好像不能应用到子查询里
with fuc as (.....)
select a.firstime,b.lasttime
from
(
select f_username, firstime
from
(
selectf_username,f_addtime as firstime,ROW_NUMBER() OVER (PARTITION BY f_username ORDER BY f_addtime asc) rowrid
fromfuc
) where rowrid =1
)
a left join
(
select f_username, lasttime
from
(
selectf_username,f_addtime as lasttime,ROW_NUMBER() OVER (PARTITION BY f_username ORDER BY f_addtime desc) rowrid
fromfuc
) where rowrid =1
)b on a.f_username=b.f_username
|