select count(*) as total from(select count(*) from tab_cb_casim group by `card_no`) as cai;

子查询必须加一个别名才能执行!!

posted on 2015-11-23 15:04  caigan  阅读(454)  评论(0编辑  收藏  举报