sql常用語句舉例(已修改)
2025-08-05 08:04 本頁面
【正文】 SQL常用語句+舉例相關表：Store_information表Store_namesalesdateLos Angeles$1500Jan051999San Diego$250Jan071999Los Angeles$300Jan081999Boston$700Jan081999Geography表Region_nameStore_nameEastBostonEastNew YorkWestLOS AngelesWestSan Diego1. distinct: 剔除重復記錄例：select distinct stroe_name from Store_informationStore_nameLos AngelesSan DiegoBoston結果：2. And / or: 并且/或 例：在表中選出所有sales 高于$1000或是sales在$275及$500之間的記錄Select store_name ,sales from Store_information Where sales1000Or (sales275 and sales 500)Store_namesalesLos Angeles1500San Diego300結果： 3. In(... , ...) :在括號內可以有一個或多個值例：在表中查找store_name包含 Los Angeles 或San Diego的記錄Select * from Store_information where store_name in (‘Los Angeles’,’San Diego’)結果：Store_namesalesdateLos Angeles$1500Jan051999San Diego$25
試題試卷相關推薦
鄂ICP備17016276號-1