DEV Community

loading...

MySQL INTERSECT

injiri profile image Simon O. Injiri ・1 min read

Returns distinct rows between two or more queries i.e
(SELECT column_list FROM tabel1 )
INTERSECT
(SELECT column_list table2)

For this, to work both columns must have the dame data types,
columns in both queries, have to match

Discussion

pic
Editor guide