找回密码
 注册
搜索
热搜: 回贴

sql查询重复行

2010-1-31 08:07| 发布者: admin| 查看: 73| 评论: 0|原作者: 江海

SELECT phone,COUNT(*) FROM UID GROUP BY phone HAVING COUNT(*)>1

最新评论

相关分类

QQ|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )

GMT+8, 2024-9-29 17:26 , Processed in 0.168722 second(s), 12 queries , Gzip On, MemCache On.

Powered by Discuz! X3.5

© 2001-2023 Discuz! Team.

返回顶部