Python Programming
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment