February 2014
Beginner
1248 pages
62h 25m
English
• The optional WHERE clause (p. 1053) in a query specifies the selection criteria for the query. The basic form of a query with selection criteria (p. 1052) is
SELECT columnName1, columnName2, ... FROM tableName WHERE criteria
• The WHERE clause can contain operators <, >, <=, >=, =, <> and LIKE. LIKE (p. 1053) is used for string pattern matching (p. 1053) with wildcard characters percent (%) and underscore (_).
• A percent character (%; p. 1053) in a pattern indicates that a string matching the pattern can have zero or more characters at the percent character’s location in the pattern.
• An underscore (_ ; p. 1053) in the pattern string indicates a single character at that position in ...
Read now
Unlock full access