数据库--去重查询

select DISTINCT regName from member ;

统计去重后数据

select COUNT(DISTINCT regName) from member ;

posted @ 2021-06-27 17:39  测试人员-凯  阅读(46)  评论(0)  编辑  收藏  举报