sql常用語句舉例(專業(yè)版)
【正文】 SQL常用語句+舉例相關(guān)表：Store_information表Store_namesalesdateLos Angeles$1500Jan051999San Diego$250Jan071999Los Angeles$300Jan081999Boston$700Jan081999Geography表Region_nameStore_nameEastBostonEastNew YorkWestLOS AngelesWestSan Diego1. distinct: 剔除重復(fù)記錄例：select distinct stroe_name from Store_informationStore_nameLos AngelesSan DiegoBoston結(jié)果：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結(jié)果： 3. In(... , ...) :在括號(hào)內(nèi)可以有一個(gè)或多個(gè)值例：在表中查找store_name包含 Los Angeles 或San Diego的記錄Select * from Store_information where store_name in (‘Los Angeles’,’San Diego’)結(jié)果：Store_namesalesdateLos Angeles$1500Jan051999San Diego$25
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1