Friday, April 24, 2009

INTERSECT

Get the same records exists in two tables.
I never use this in my job.


SELECT CITY
FROM ACCOUNT
INTERSECT
SELECT CITY
FROM CONTACT

No comments:

Post a Comment

Oracle Query