every derived table must have its own alias

来源:互联网 发布:java scanner用法int 编辑:程序博客网 时间:2024/05/17 07:07

select count(id) from (select tt.id from supe_qawiner tt GROUP BY tt.mobile) 


为表加一个别名

======>

select count(id) from (select tt.id from supe_qawiner tt GROUP BY tt.mobile) cccc