作者ayu1392010 (莫名我想她)
看板Database
标题Re: [SQL ] M$-SQL2000的语法问题
时间Mon Jan 8 17:04:32 2007
※ 引述《flakchen (flak)》之铭言：
: 看起来是用衍生资料表、暂存资料表或资料表变数
: SELECT 业务,业绩1998.业绩 as 1998业绩,业绩1997.业绩 as 1997业绩
: FROM (select 业务,业绩 from 业务资料表
: where Year=1998 group by 业务) as 业绩1998
: INNER JOIN
: (select 业务,业绩 from 业务资料表
: where Year=1997 group by 业务) as 业绩1997
: ON 业绩1998.业务=业绩19987.业务
我试了一下 还是不知道要怎麽写 囧 我附上我的程式码 我要将1998业绩当作X
1997业绩当作Y 然後我要用另外一个SELECT做XY的运算 其中要包含 "业务员姓名",
"1998 业绩", "1997 业绩", "增减量","增减百分比" 五个栏位
先拜谢各位大大....
:select FirstName+' '+LastName as 业务员姓名,round([Order Details].UnitPrice
* [Order Details].Quantity * (1-[Order Details].Discount) , 0) as [1998 业绩]
from Orders, Employees,[Order Details]
where Orders.OrderID = [Order Details].OrderID and Orders.EmployeeID =
Employees.EmployeeID and YEAR(Orders.RequiredDate) = 1998
select FirstName+' '+LastName as 业务员姓名,round([Order Details].UnitPrice
* [Order Details].Quantity * (1-[Order Details].Discount) , 0) as [1997 业绩]
from Orders, Employees,[Order Details]
where Orders.OrderID = [Order Details].OrderID and Orders.EmployeeID =
Employees.EmployeeID and YEAR(Orders.RequiredDate) = 1997
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 125.231.122.140