TO:ccbzzp
SQL> select id,pid,d1,d2 from test order by d2;
ID PID
D1 D2
-------- -------- ---------- ----------
ab
1
1
bc
2
2
cd
2
3
de
3
4
ef
2
5
已用时间:00: 00: 00.80
SQL>select A.d2,A.id,A.pid,
2 (A.d1*B.d1)OVER(select d2 from test A ORDER BY A.d2)
3 FROM test A,test B
4 where a.d2=(b.d2-1);
(A.d1*B.d1)OVER(select d2 from test A ORDER BY A.d2)
*
ERROR 位于第 2 行:
ORA-00923: 未找到预期 FROM 关键字
已用时间:00: 00: 00.60
|