读书人

Every derived table must have its o

发布时间: 2012-07-04 19:33:55 作者: rapoo

Every derived table must have its own alias(每一个派生表必须有它自己的别名)
每一个派生表必须有它自己的别名
select count(*) from (select t.a from test t group by t.a)
解决办法:
select count(*) from (select t.a from test t group by t.a)c

读书人网 >其他数据库

热点推荐