MySql count去掉重复语句

来源:互联网 发布:mac微信截图如何保存 编辑:程序博客网 时间:2024/06/16 11:31


MySql count去掉重复语句

1.select count(distinct SName) from Student

2.select count(SName) from (select distinct SName from Student) as temp

as可有可无。temp作为别名,若无则提示错误:1248 – Every derived table must have its own alias

 

原创粉丝点击