1、distinct select count(distinct CName) from teble select count(CName) from (select dist
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
--结束END--
本文标题: mysql去重查询表中数据
本文链接: https://www.lsjlt.com/news/35791.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0