MySQL: difference of two result sets
Posted
by Zombies
on Stack Overflow
See other posts from Stack Overflow
or by Zombies
Published on 2010-04-27T18:19:53Z
Indexed on
2010/04/27
18:23 UTC
Read the original article
Hit count: 210
mysql
|set-difference
How can I get the set difference of two result sets?
Say I have a result set (just one column in each):
result1:
'a'
'b'
'c'
result2:
'b'
'c'
I want to minus what is in result1 by result2: result1 - result2 such that it equals:
difference of result1 - result2:
'a'
© Stack Overflow or respective owner