SELECT Categories.CategoryName, Products.ProductName,
Sum(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ProductSales
FROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID)
INNER JOIN (Orders
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)
ON Products.ProductID = "Order Details".ProductID
WHERE (((Orders.ShippedDate) Between '19970101' And '19971231'))
GROUP BY Categories.CategoryName, Products.ProductName
Sum(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ProductSales
FROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID)
INNER JOIN (Orders
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)
ON Products.ProductID = "Order Details".ProductID
WHERE (((Orders.ShippedDate) Between '19970101' And '19971231'))
GROUP BY Categories.CategoryName, Products.ProductName
解决方案 »
- int自增类型字段需要再加索引吗?
- [DBNETLIB][ConnectionOpen(connect()).]SQL Server 不存在或拒绝访问 的问题
- 帮把这PL/SQL转化为T-SQL,THX
- 关系模型中的关系,元组怎么理解?
- 求一sql 请高手们该出手就出手吧!?
- sql server 2000新手弱问:查找最近的日期
- http://www.cxge.com:8888
- MSHFlexGrid控件不支持存储过程里定义的表吗
- 求教一个2个表互换循环的存储过程
- 修改
- 存储过程简单问题,参与有分,急急急!!!!!!!!!!!!!!
- SQL语句:查询“出现次数大于某数值“的记录的SQL语句,How To?
SELECT dbo_employee_work.shopname, dbo_employee_work.indate, dbo_employee_work.employee, dbo_employee_work.product, dbo_employee_work.workname, dbo_employee_work.finish_num, dbo_employee_work.bad_num
FROM dbo_employee_work
WHERE (((dbo_employee_work.indate)>=[开始日期] And (dbo_employee_work.indate)<=[截止日期]) AND ((dbo_employee_work.employee) Not Like '*材料*' And (dbo_employee_work.employee) Not Like '*柴桥*') AND ((dbo_employee_work.product)<>"0"));
--联合字段查询
where isnull(dh1,'') + '任意特殊字符' + isnull(dh2,'') +
'任意特殊字符' + isnull(dh3,'') + ...... +
'任意特殊字符' + isnull(dh7,'') like '%查询字串%'
学生学习课程表sc(s#,c#,grade)
要求写出:
学习了所有课程的学生号select distinct s# from sc a
where not exists
(
select 1 from c
where c# not in(select c# from sc where s#=a.s#)
)
有没有用Group by等等的?!