初学者请大家帮忙看下

[haode_qu]

select * from xxh where id in(select min(id) from xxh group by name2)加上where name1='张三'

要的是name1里张三的name2里的记录
如果name1里有一条是李四,那就不显示是李四的name2里的那条记录

[lishan200012]

select *,count(*) from xxh where id in(select min(id) from xxh group by name2)加上where name1='张三' and count(*)>1
试试

[lishan200012]

上面的写错了。

[lishan200012]

select name1,count(*) from xxh where id in(select min(id) from xxh group by name2)加上where name1='张三' and count(*)>1 group by name1