CIS 275 - DB2/SQL - Notes

SELECT determines (up to 750) columns to be returned.
FROM determines the table (up to 15) to be accessed by the query.
WHERE gives the conditions upon which the instances are returned.
In MS Access, BETWEEN is inclusive of the outermost values.
In MS Access, a count of a file with NULLs does not include NULLs as part of the final total.
In MS Access, an average does not include NULLs as part of the calculation.
In MS Access, the asterisk replaces the percent sign as a wild card representing from 0 to many characters.
In MS Access, the question mark replaces the underscore as a wild card representing one character.
In MS Access, surround the date with pound signs.
For further information, go to the alphabetical index of SQL.

Thanks to the following people for suggesting some of the above DB2/SQL notes . . .