ITM 500 Lecture Notes - Lecture 4: Relational Operator, Aggregate Function, Database Design

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

Document Summary

The queries presented in module 2 resulted in 1 row of output for every row that was selected based on the conditions in the where clause. The major topic of this module will involve the aggregation of multiple selected rows into a single row of output. This output will contain the result of built in sql aggregate mathematical functions. To follow the examples and the your turn" exercises it is recommended to have sql. Server"s management studio opened and the university database attached. List the details for all courses that have the characters "business" anywhere in the course description. This is looking for any entry that has the characters business anywhere in its course description. The %" is a wild card and represents any number of characters from zero to many. Don"t use a relational operator (e. g. =") as it will look literally for a description that contains the %". A negative test for a strings uses not like.