B ITM 330 Lecture Notes - Lecture 5: Wildcard Character, Negation

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 330
• Professor: Jakov Crnkovic

Document Summary

The where clause may include the in keyword to specify that a particular. Sql for data retrieval a list of values: column value must be included in a list of values. Sql for data retrieval the logical not operator: Any criteria statement may be preceded by a not operator, which is to say that all information will be shown except that information matching the specified criteria. Sql for data retrieval finding data in a range of values: sql provides a between keyword that allows a user to specify a minimum and maximum value on one line. Access: single character wildcard character is an underscore (_). Sql for data retrieval sorting the results: query results may be sorted using the order by clause. Sql for data retrieval providing subtotals: group by: subtotals may be calculated by using the group by clause, the having clause may be used to restrict which data is displayed.