MySql count去掉重复语句_MySQL
- WBOY原创
- 2016-06-01 13:42:451263浏览
bitsCN.com
MySql count去掉重复语句 1.select count(distinct CName) from Course
2.select count(CName) from (select distinct CName from Course) as temp
as可有可无。temp作为别名，若无则提示错误：1248 – Every derived table must have its own alias
摘自 王贺的博客 bitsCN.com
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn