|
〇〇 发表于 2014-6-28 12:26 ![]()
/tmp/xugu_lin_x64 -daemon
XuGu SQL Server 8.1.0 (Built:2014-06-18 00:30:00.052702)
Start at: 2014 ...
仍然不支持connect by level
SQL>with t as(select level t from dual connect by level<=1e4)
2 ,s as(select level s from dual connect by level<=5e3)
3 ,a as(select (s-1)*1e4+t a from t,s)
4 select substr(a,-1,1)x,sum(a)s from a
5 group by substr(a,-1,1)
6 order by 1;
Error: [E19224] Connect by 表达式错误 |
|