我只是在玩SQL,并想要实现以下结果。我有以下表:
TABLE_1 ID NAME
1 CAR
2 ANIMAL
5 ROCK
TABLE_2 ID NAME
1 GRASS
2 ROCKET
3 STONE
4 DOG
我希望我的查询结果能够返回两个表中唯一的ID值:
ID
3
4
5
我尝试使用DISTINCT和FULL OUTER JOINS,但没有成功。 希望能得到帮助。
SELECT ID FROM ( SELECT ID FROM Table_1 UNION ALL SELECT ID FROM Table_2) AS my_alias GROUP BY ID HAVING COUNT(*) = 1
- Kalyan Halder