资源描述：
《SQL语法大全(个人笔记)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Sql指令üSelectStore_NameFromStore_InformationüSelectDistinctStore_NameFromStore_InformationüSelectStore_NameFromStore_InformationWhereSales>1000üSelectStore_NameFromStore_InformationWhereSales>1000Or(Sales<500AndSales>275)üSelect*FromStore_InformationWhereStore_NameIn('LosAngeles','SanDiego')
2、üSelect*FromStore_InformationWhereDateBetween'Jan-06-1999'And'Jan-10-1999'üSql中有两个通配符：%(百分比符号)：代表零个、一个、或数个字母。_(底线)：代表刚好一个字母。通配符是与Like关键词一起使用的üSelect*FromStore_InformationWhereStore_NameLike'%An%'üSelectStore_Name,Sales,DateFromStore_InformationOrderBySalesDescüAvg(平均)SelectAvg(Sales)FromSto
3、re_InformationüCount(计数)：SelectCount(Store_Name)FromStore_InformationWhereStore_NameIsNotNullSelectCount(DistinctStore_Name)FromStore_InformationüMax(最大值)SelectMax(Sales)FromStore_InformationüMin(最小值)SelectMin(Sales)FromStore_InformationüSum(总合)SelectSum(Sales)FromStore_InformationüSelectSt
4、ore_Name,Sum(Sales)FromStore_InformationGroupByStore_NameüSelectStore_Name,Sum(Sales)FromStore_InformationGroupByStore_NameHavingSum(Sales)>1500ü别名：SelectA1.Store_NameStore,Sum(A1.Sales)"TotalSales"FromStore_InformationA1GroupByA1.Store_NameüAs:SelectA1.Store_NameStore,Sum(A1.Sales)As"Total
5、Sales"FromStore_InformationAsA1GroupByA1.Store_Nameü连接：SelectRegion_Name+''+Store_NameFromGeographyWhereStore_Name='Boston'üSubstr(Str,Pos,Len):由中的第位置开始，选出接下去的个字符。SelectSubstr(Store_Name,2,4)FromGeographyWhereStore_Name='SanDiego'üLtrim(字符串):将所有字符串起头的空白移除。Rtrim(字符串):将所有字符串结尾的
6、空白移除。üLength(Str):找出Str字符串的长度üReplace(Str1,Str2,Str3):在字符串Str1中，当Str2出现时，将其以Str3替代。SelectReplace(Region_Name,'Ast','Astern')FromGeography表格处理ü创建表格CreateTableCustomer(First_NameChar(50),Last_NameChar(50),AddressChar(50),CityChar(50),CountryChar(25),Birth_DateDate)ü非空CreateTableCustomer(SidIn
7、tegerNotNull,Last_NameVarchar(30)NotNull,First_NameVarchar(30))üUnique限制是保证一个字段中的所有数据都是有不一样的值。CreateTableCustomer(SidIntegerUnique,Last_NameVarchar(30),First_NameVarchar(30))üCheck限制是保证一个字段中的所有数据都是符合某些条件。CreateTableCustomer(SidIntegerCheck(Sid>0),Last_Na
