扫码关注官方订阅号
一个表有50万行 怎么选取相同的行?
select * from table1 a where (select count(1) from table1 where col1=a.col1)>1
太慢了,好久了还木有出来~ 求招式阿~
认证0级讲师
试试这个呢SELECT * FROM table GROUP BY col HAVING count(col)>1
SELECT * FROM table GROUP BY col HAVING count(col)>1
微信扫码关注PHP中文网服务号
QQ扫码加入技术交流群
扫描下载App
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
PHP学习
技术支持
返回顶部
试试这个呢
SELECT * FROM table GROUP BY col HAVING count(col)>1