How_to_retrieve_data_from_a_single_table/demo-queries-from slides-7.sql

--A SELECT statement that returns all rows
SELECT vendor_city, vendor_state
FROM vendors
ORDER BY vendor_city;

--A SELECT statement that eliminates duplicate rows
SELECT DISTINCT vendor_city, vendor_state
FROM vendors
ORDER BY vendor_city;