sql常用語句舉例-在線瀏覽
2024-09-03 08:04本頁面
【正文】 p結(jié)合使用語法：select 字段1, sum(字段2) from 表名Group by 字段1Having(函數(shù)條件)例：Select store_name,sum(sales) from Store_information group by store_nameHaving sum(sales) $1500store_namesum(sales)Los Angeles$1800結(jié)果：11. Alias :別名，字段別名和表格別名語法：select 字段名 AS 字段別名 from 表名 AS 表別名例：select store_name AS store from Store_information AS S1結(jié)果 ：storeLos AngelesSan DiegoLos AngelesBoston12. 左連接/內(nèi)部連接例：查找每一區(qū)域的salesSelect , from Geography AS A2,Store_information AS A1Where =Group by regionsaleseast$700west$2050結(jié)果：13. 外部連接 : +例：我們需要查找每一個(gè)店的營業(yè)額，如果我們用一個(gè)普通連接，就會漏掉 new york這個(gè)店，這時(shí)我們要用外部連接Select ,sum() from eography AS A1,Store_information AS A2Where =(+)Group by 14. Creat table:創(chuàng)建表Creat table custome(first_name char(50),Lat_name char(50),Birth_date date)15. Creat view：創(chuàng)建視圖Creat view V_customeAS select first_na
試題試卷相關(guān)推薦
鄂ICP備17016276號-1