CREATE TABLE t AS
SELECT *
FROM (SELECT COUNT(*) AS n, classname
FROM classInfo AS c1
GROUP BY classname)
分组查询的结果集可以用select into 创建新表
最新推荐文章于 2019-01-15 23:39:00 发布
CREATE TABLE t AS
SELECT *
FROM (SELECT COUNT(*) AS n, classname
FROM classInfo AS c1
GROUP BY classname)