Sqlserver查询重复记录

SELECT

         *

FROM

         xzllgj_user_free_60m

WHERE

         user_id IN (

                   SELECT

                            user_id

                   FROM

                            xzllgj_user_free_60m

                   GROUPBY

                            user_id

                   HAVING

                            (COUNT(*))> 1

         )

阅读更多
文章标签: SQLServlet sql
个人分类: Sqlserver
上一篇Sqlserver获取自增长id
下一篇Sqlserver case...when + union 用法
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭