CSC 4402 20090923

CSC 4402 20090923 - Subquery evaluation is not efficient....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC 4402 9/23/2009 Page 1 of 1 SQL The having clause is handy because if the same clause were put in the where clause, it would eliminate rows, rather than compute an aggregate operation. Pay attention to “Three Valued Logic” and IS/IS NOT clauses.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Subquery evaluation is not efficient. Subqueries can be used in select, from, and where clauses. Note use of some , all , and e xists clauses....
View Full Document

Ask a homework question - tutors are online