What is Intersect?

What is Intersect?

What is Intersect?

View Answers

November 20, 2010 at 12:32 PM

Hi,

The INTERSECT query allows you to return the results of two or more "select" queries. However, it only returns the rows selected by all queries. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results.

The syntax is as follows:

[SQL Statement 1]
INTERSECT
[SQL Statement 2]

thanks,









Related Tutorials/Questions & Answers:
what is bit
what is hibernate.archive.autodetection
Advertisements
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
What is procedure
what is hibernate.archive.autodetection
What is Hibernate
What is Hibernate
What is Hibernate
What is JDBC?
What is FBT
What is ActionServlet?
What is Trigger?
What is VLR ?
What's PHP ?
What is an interface?
What is DML?
What is Index?
What is SQLLoader?
What is a "constraint"?
what is Savepoint ?
What is this keyword?
what is collections?
what are indices?
What is Hibernate
What is Externalizable?
What is the % operator?
What is casting?
What is DataAccessException?
What is IOC ?
What is SQLExceptionTranslator?
What are Struts?
What is WAP?
What is SPOOL?
What is CRM?
What is webservices?
What is Ajax?
What is NSRangeException
What is portal
what is posting?
What is a tuple?
What is workflow
what is RUP?
What was ENIAC
What is an Iterator?
What is EDGE?
What is WSP?
What is CDPD ?

Ads