sql怎么找到工资相同的人,怎么用代码实现在SQL中找出名字相同的人,下面维维给大家带来相关解答。
我是一个才学习编程的人,如果想显示某一列中有重复值的行,可以这样写:
假设要查重复值的列名为Col
Select * From Table where Col in(Select Col From Table group by Col having count(*)>1)
select * from tablename where name=(select name from tablename group by name having count(name)>1)
这里tablename就是你的表名 name是姓名
select * from tablename where name in (select name from tablename group by name having count(name)>1)