-
table的展開 DB diagram中新建E-R圖(實體-聯系圖entity relationship diagram) eg:1.modify 或者再進行（右鍵）zoom->to fit 2.(右鍵）add tables查看全部
-
有個單詞叫 ？發音類似 skima查看全部
-
SSMS(SQL SERVER MANAGEMENT STUDIO)是微軟的<br> 幾大數據庫巨頭：SQL MYSQL DB2 Mongo DB Oracle<br> 用戶client輸入的數據(desktop)->web server->DB server查看全部
-
SSMS(SQL SERVER MANAGEMENT STUDIO)是微軟的 幾大數據庫巨頭：SQL MYSQL DB2 Mongo DB Oracle 用戶client輸入的數據(desktop)->web server->DB server查看全部
-
經典SQL query! select SalesPersonID, OrderDate,Max(TotalDue) as MaximumTotalSales from [Sales].[SalesOrderHeader] where SalesPersonID is not null and OrderDate>='2007/1/1' group by SalesPersonID, OrderDate having Max(TotalDue)>150000 order by SalesPersonID查看全部
-
having限制聚合函數：having max(TotalDue)>5000查看全部
-
select 單位名稱,count(職工id),sum(職工工資) form [某表] group by 單位名稱 這樣的運行結果就是以“單位名稱”為分類標志統計各單位的職工人數和工資總額。 在sql命令格式使用的先后順序上，group by 先于 order by。查看全部
-
select SalesPersonID, max(TotalDue) as MaximumTotalSales from [sales].[salesorderheader] group by salespersonID order by salespersonID 沒有后兩句會出錯查看全部
-
select avg(totaldue)as averageTotalSales from [sales].[salesorderheader] select avg(totaldue)as averageTotalSales ,min(totaldue)as minTotalSales ,max(totaldue)as averageTotalSales ,sum(totaldue)as averageTotalSales from [sales].[salesorderheader]查看全部
-
select count(distinct(salespersonID)......查看全部
-
獨一無二的記錄個數 select distinct(salepersonID) from [sales].[salesorderheader] where salespersonID is nout null查看全部
-
統計記錄個數 select count(salespersonID) from [sales].[salesorderheader] where salespersonID is not null查看全部
-
where size is null where size is not null查看全部
-
where size in ('60','61','62') wehre class not in ('H')查看全部
-
where name like"%mountain%" Where name like"_mountain%"查看全部
舉報
0/150
提交
取消