Returns the common rows between two SELECT statements.
Example:
TABLE1 has one column with the following data: a,b,c,d,e,f,g
TABLE2 contains: c,d,f,x,z,
SELECT * FROM TABLE1 INTERSECT SELECT * FROM TABLE2
Results in the following: c,d,f
Returns the common rows between two SELECT statements.
Example:
TABLE1 has one column with the following data: a,b,c,d,e,f,g
TABLE2 contains: c,d,f,x,z,
SELECT * FROM TABLE1 INTERSECT SELECT * FROM TABLE2
Results in the following: c,d,f
Comments
Please sign in to leave a comment.