ITM 500 Lecture Notes - Lecture 2: Logical Connective, The Stig

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Raymond Moss

Document Summary

When coupled with the appropriate search conditions, select is a powerful tool that enables you to transform data into information. You can select partial tables contents by placing restrictions on the rows to be included in the output. The where clause is used to add conditional restrictions to the select statement. The following syntax enables you to specify which rows to select: The select statement retrieves all rows that match the specified condition(s) you specified in the where clause. Example: select p_descript, p_indate, p_price, v_code from product where. This returns the description, date, and price of products with a vendor code of. The following example uses the (cid:862)not equal to(cid:863) operator: The following command would yield a list of all rows in which the p_code is alphabetically less than 1558-qwi: Select p_code, p_descript, p_qoh, p_min, p_price from product where. String (character) are made from left to right which is useful when attributes such as names are compared.