Store_Information表格
store_name | Sales | Date |
Los Angeles | $1500 | Jan-05-1999 |
San Diego | $250 | Jan-07-1999 |
Los Angeles | $300 | Jan-08-1999 |
Boston | $700 | Jan-08-1999 |
我们就打入,
SELECT DISTINCT store_name FROM Store_Information
结果:
store_name |
Los Angeles |
San Diego |
Boston |