1、distinct
select count(distinct CName) from teble
select count(CName) from (select distinct CName from Course) as temp
SELECT DISTINCT text_zhcn FROM dms_menuconfig -- 去重查询表中数据
select DISTINCT(user_id) from user_info where children_merchant_id='kuaiditong';2、group by
select count(1) from Course group by CName文档：mysql去重查询表中数据.note
链接：http://note.youdao.com/noteshare?id=581440d92396bab4de6568d1a69baa58&sub=9B8DAB091CC5490BA5F8FA29557CCD67
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
