同样的表,同样的代码:
create table t11_bak as (
select t1.*,t2.totalnum from t11 t1,(
select t.name,count(distinct t.item) totalnum from t11 t
group by t.name
) t2
order by t2.totalnum
)
在MYSQL里运行OK 在SQLSERVER2005里就报错
我在SQLSERVER是先打开表 再打开这张表的SQL代码界面运行的 问题出在哪?
create table t11_bak as (
select t1.*,t2.totalnum from t11 t1,(
select t.name,count(distinct t.item) totalnum from t11 t
group by t.name
) t2
order by t2.totalnum
)
在MYSQL里运行OK 在SQLSERVER2005里就报错
我在SQLSERVER是先打开表 再打开这张表的SQL代码界面运行的 问题出在哪?
select t1.*,t2.totalnum into t11_bak from t11 t1,(
select t.name,count(distinct t.item) totalnum from t11 t
group by t.name
) t2
order by t2.totalnum
就是用来生成新表的.
a.*,b.totalnum
into
t11_bak from t11 a,(select t.name,count(distinct t.item) totalnum from t11 t
group by t.name)b
order by
b.totalnum