November 29, 2009

SQL(I)的練習

1.SELECT CompanyName AS 貨運公司名稱,Phone AS 電話
FROM Shippers
WHERE ShipperID 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);

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

由 b506097104 發表於 November 29, 2009 08:42 PM
迴響
發表迴響









記住我的資訊?





請依上圖輸入檢核碼: