USE Mall Go SET NOCOUNT ON ---------- retrieving with limited ---------- -- ********** Begin ********** -- SELECT prod_name FROM Products WHERE prod_name LIKE '%toy%' -- ********** End ********** -- GO ---------- retrieving with expression ---------- -- ********** Begin ********** -- SELECT prod_price, prod_price * 0.8 AS discount_price FROM Products WHERE prod_price > 3 -- ********** End ********** -- GO