6.24 Slide #56

/* slide#56 Concatenate strings  */
SELECT  concat(buyer,' in ',department) AS Buyer_In_Department
FROM    SKU_DATA 
;
TABLE6.30: 8 records
Buyer_In_Department
Pete Hansen in Water Sports
Pete Hansen in Water Sports
Nancy Meyers in Water Sports
Nancy Meyers in Water Sports
Cindy Lo in Camping
Cindy Lo in Camping
Jerry Martin in Climbing
Jerry Martin in Climbing

Remove duplicates from the query above:

/* slide#56 Concatenate strings  */
SELECT  DISTINCT concat(buyer,' in ',department) AS Buyer_In_Department
FROM    SKU_DATA 
;
TABLE6.31: 4 records
Buyer_In_Department
Pete Hansen in Water Sports
Nancy Meyers in Water Sports
Cindy Lo in Camping
Jerry Martin in Climbing