Go语言视频零基础入门到精通

apekji

有table A

id, number name
1 02 a
2 02 a
3 03 b
4 03 d
5 03 d
6 04 x
7 04 y
8 05 e
9 05 e

求 SQL ， 希望查出number相同但name不同的所有记录。期望查询结果如下：

id, number name
3 03 b
4 03 d
6 04 x
7 04 y

时间旅人

SQL code select distinct A.*
from table_name A,
     table_name B
where A.number = B.number
  and A.name <> B.name

java开源

SQL code select *
from A t
where exists (select 1 from A where number=t.number and name!=t.name)

yy1020

select distinct A.*
from table_name A,
  table_name B
where A.number = B.number
  and A.name <> B.name

不行 有重复的哦。楼主题目中的 4 和 5 id不一样其他一样。你这样关联跟楼主要求结果不一样的。多了个
5 03 d

太阳城

SELECT * FROM (SELECT table1.number, table1.name
FROM table1
GROUP BY table1.number, table1.name) B  
WHERE number IN (SELECT NUMBER FROM (
SELECT a.number, Count(*) AS Rec
FROM [SELECT table1.number, table1.name
FROM table1
GROUP BY table1.number, table1.name]. AS a
GROUP BY a.number
HAVING (Count(*)>1)) G);

2878qw