mysql指定字段去重

select theme_id, theme_name,theme_color,COUNT(DISTINCT theme_name) from bkgmag GROUP BY theme_name  利用COUNT函数和Group By 去重字段

posted @ 2021-11-24 14:27  unlimitedbladeworks  阅读(165)  评论(0)    收藏  举报