作者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