SQL语法大全(个人笔记).docx

Sql指令Select Store_Name From Store_InformationSelect Distinct Store_Name From Store_InformationSelect Store_Name From Store_Information Where Sales 1000Select Store_Name From Store_Information Where Sales 1000 Or (Sales 500 And Sales 275)Select * From Store_Information Where Store_Name In (Los Angeles, San Diego)Select * From Store_Information Where Date Between Jan-06-1999 And Jan-10-1999Sql 中有两个通配符：% (百分比符号)：代表零个、一个、或数个字母。_ (底线)：代表刚好一个字母。通配符是与Like关键词一起使用的Select * From Store_Information Where Store_Name Like %An%Select Store_Name, Sales, Date From Store_Information Order By Sales DescAvg (平均) Select Avg(Sales) From Store_InformationCount (计数) ：Select Count(Store_Name) From Store_Information Where Store_Name Is Not NullSelect Count(Distinct Store_Name) From Store_InformationMax (最大值)Select Max(Sales) From Store_InformationMin (最小值)Select Min(Sales) From Store_InformationSum (总合)Select Sum(Sales) From Store_InformationSelect Store_Name, Sum(Sales) From Store_Information Group By Store_NameSelect Store_Name, Sum(Sales) From Store_Information Group By Store_NameHaving Sum(Sales) 1500别名：Select A1.Store_Name Store, Sum(A1.Sales) Total Sales From Store_Information A1Group By A1.Store_NameAs :Select A1.Store_Name Store, Sum(A1.Sales) As Total SalesFrom Store_Information As A1Group By A1.Store_Name连接：Select Region_Name + + Store_Name From Geography Where Store_Name = BostonSubstr(Str,Pos,Len): 由Str中的第Pos位置开始，选出接下去的Len个字符。Select Substr(Store_Name,2,4) From Geography Where Store_Name = San DiegoLtrim(字符串): 将所有字符串起头的空白移除。Rtrim(字符串): 将所有字符串结尾的空白移除。Length(Str): 找出Str字符串的长度Replace(Str1, Str2, Str3): 在字符串 Str1 中，当 Str2 出现时，将其以 Str3 替代。Select Replace(Region_Name, Ast, Astern)From Geography表格处理创建表格Create Table Customer(First_Name Char(50),Last_Name Char(50),Address Char(50),City Char(50),Country Char(25),Birth_Date Date)非空Create Table Customer (Sid Integer Not Null, Last_Name Varchar (30)