Thursday, October 15, 2015

SQL -- Select Statement




1. Select the customerid, order_date, and item values from the items_ordered table for any items in the item column that start with the letter "S".

SELECT customerid, order_date, item, price
FROM items_ordered
WHERE item LIKE 'S%';




No comments:

Post a Comment