-
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
提交
取消