December 07, 2009

SQL_II

select sum(UnitPrice*Quantity)AS 訂單總額
from OrderDetails
where OrderID in
(select OrderID
from Orders
where EmployeeID in (3)
);


SELECT EmployeeID AS 員工編號
FROM Employees
where Birthdate in
(select min(Birthdate)
FROM Employees
);


select sum(UnitPrice*Quantity)AS 訂單總額
from OrderDetails
where OrderID in
(select OrderID
from Orders
where EmployeeID in
(SELECT EmployeeID AS 員工編號
FROM Employees
where Birthdate in
(select min(Birthdate)
FROM Employees))
);

由 b202098055 發表於 December 7, 2009 09:42 PM
迴響

white mbt shoes b202098055: SQL_II

Posted by: where to buy mbt shoes 發表於 November 22, 2013 01:49 AM

Hi, Neat post. There’s a problem with your site in internet explorer, would check this… IE still is the market leader and a large portion of people will miss your fantastic writing due to this problem.

Posted by: Kurtis 發表於 July 5, 2014 07:23 AM
發表迴響









記住我的資訊?





請依上圖輸入檢核碼: