November 28, 2009

SQL

SQL

(1)SELECT CompanyName AS 貨運公司名稱,Phone AS 電話
FROM Suppliers
WHERE SupplierID IN (1,2);

(2)SELECT CustomerID AS 客戶編號
FROM Orders
WHERE ShipVia IN
(SELECT ShipperID
FROM Shippers
WHERE CompanyName IN ('United Package','Federal Shipping' ))
AND ShippedDate Between CDate('2002/11/9')And CDate('2002/11/16')AND
EmployeeID IN (1,6,9)
ORDER BY CustomerID DESC;

(3)SELECT CategoryName AS 類別名稱
FROM Categories
WHERE Description LIKE '*pasta*';

由 b202098055 發表於 November 28, 2009 07:59 PM
迴響
發表迴響









記住我的資訊?





請依上圖輸入檢核碼: