sql指令應(yīng)用介紹ppt課件-資料下載頁(yè)
2025-01-12 09:50本頁(yè)面
【正文】 ProductModelID = 21 AND Color = 39。Red39。 SELECT ProductID, ProductModelID, Color FROM WHERE (ProductModelID = 20 OR ProductModelID = 21) AND Color = 39。Red39。 取回指定範(fàn)圍內(nèi)的資料 (使用 BETWEEN AND關(guān)鍵字 ) SELECT ProductID, Name,ListPrice FROM WHERE ListPrice BETWEEN 20 AND 25 使用清單當(dāng)做搜尋條件 (使用 IN關(guān)鍵字 ) USE Northwind SELECT panyname,country From suppliers WHERE country IN (39。Japan39。,39。Italy39。,39。UK39。,39。Australia39。) 使用彙總函數(shù) SELECT SUM(Quantity) as 39。訂購(gòu)總數(shù) 39。, COUNT(Quantity) as 39。訂單筆數(shù) 39。, AVG(Quantity) as 39。平均數(shù)量 39。, MIN(Quantity) as 39。單筆訂購(gòu)最小值 39。, MAX(Quantity) as 39。單筆訂購(gòu)最大值 39。 FROM .[Order Details] WHERE ProductID=51 列出前 N 筆資料 SELECT TOP (5) EmployeeID,count(EmployeeID) 訂單數(shù)量 FROM GROUP BY EmployeeID ORDER BY 訂單數(shù)量 DESC 關(guān)連多個(gè)資料表 SELECT , LastName, FirstName, OrderDate FROM Employees a LEFT JOIN Orders b ON = 使用 SELECT INTO SELECT * INTO TT FROM ( SELECT panyname,country From suppliers WHERE country IN (39。Japan39。,39。Italy39。,39。UK39。,39。Australia39。) ) TT1 使用 Truncate 與 Drop TRUNCATE TABLE TT DROP TABLE TT
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1