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