å ä¸å¯¹[]æ¯å¯éå段.å {}æ¯å¿
éå段
ä¸.SELECTè¯å¥çå®æ´è¯æ³ä¸ºï¼
SELECT[ALL|DISTINCT|DISTINCTROW|TOP]
{*|talbe.*|[table.]field1[AS alias1][,[table.]field2[AS alias2][,â¦]]}
FROM tableexpression[,â¦][IN externaldatabase]
[WHEREâ¦]
[GROUP BYâ¦]
[HAVINGâ¦]
[ORDER BYâ¦]
[WITH OWNERACCESS OPTION]
说æï¼
ç¨ä¸æ¬å·([])æ¬èµ·æ¥çé¨å表示æ¯å¯éçï¼ç¨å¤§æ¬å·({})æ¬èµ·æ¥çé¨åæ¯è¡¨ç¤ºå¿
é¡»ä»ä¸éæ©å
¶ä¸çä¸ä¸ªã
1 FROMåå¥
FROMåå¥æå®äºSELECTè¯å¥ä¸å段çæ¥æºãFROMåå¥åé¢æ¯å
å«ä¸ä¸ªæå¤ä¸ªç表达å¼(ç±éå·åå¼)ï¼å
¶ä¸ç表达å¼å¯ä¸ºåä¸è¡¨å称ãå·²ä¿åçæ¥è¯¢æç± INNER JOINãLEFT JOIN æ RIGHT JOIN å¾å°çå¤åç»æãå¦æ表ææ¥è¯¢åå¨å¨å¤é¨æ°æ®åºï¼å¨IN åå¥ä¹åææå
¶å®æ´è·¯å¾ã
ä¾ï¼ä¸åSQLè¯å¥è¿åæææå®åç客æ·ï¼
SELECT OrderID,Customer.customerID
FROM Orders Customers
WHERE Orders.CustomerID=Customers.CustomeersID
2 ALLãDISTINCTãDISTINCTROWãTOPè°è¯
(1) ALL è¿å满足SQLè¯å¥æ¡ä»¶çææè®°å½ãå¦æ没æææè¿ä¸ªè°è¯ï¼é»è®¤ä¸ºALLã
ä¾ï¼SELECT ALL FirstName,LastName
FROM Employees
(2) DISTINCT å¦ææå¤ä¸ªè®°å½çéæ©å段çæ°æ®ç¸åï¼åªè¿åä¸ä¸ªã
(3) DISTINCTROW å¦ææéå¤çè®°å½ï¼åªè¿åä¸ä¸ª
(4) TOPæ¾ç¤ºæ¥è¯¢å¤´å°¾è¥å¹²è®°å½ãä¹å¯è¿åè®°å½çç¾åæ¯ï¼è¿æ¯è¦ç¨ TOP N PERCENTåå¥ï¼å
¶ä¸N 表示ç¾åæ¯ï¼
ä¾ï¼è¿å5%å®è´§é¢æ大çå®å
SELECT TOP 5 PERCENT*
FROM [ Order Details]
ORDER BY UnitPrice*Quantity*(1-Discount) DESC
3 ç¨ AS åå¥ä¸ºå段åå«å
å¦ææ³ä¸ºè¿åçååä¸ä¸ªæ°çæ é¢ï¼æè
ï¼ç»è¿å¯¹å段ç计ç®ææ»ç»ä¹åï¼äº§çäºä¸ä¸ªæ°çå¼ï¼å¸ææå®æ¾å°ä¸ä¸ªæ°çåéæ¾ç¤ºï¼åç¨ASä¿çã
ä¾ï¼è¿åFirstNameå段åå«å为NickName
SELECT FirstName AS NickName ,LastName ,City
FROM Employees
ä¾ï¼è¿åæ°çä¸åæ¾ç¤ºåºåä»·å¼
SELECT ProductName ,UnitPrice ,UnitsInStock ,UnitPrice*UnitsInStock AS valueInStock
FROM Products
äº .WHERE åå¥æå®æ¥è¯¢æ¡ä»¶
1 æ¯è¾è¿ç®ç¬¦
æ¯è¾è¿ç®ç¬¦ å«ä¹
= çäº
> 大äº
< å°äº
>= 大äºçäº
<= å°äºçäº
<> ä¸çäº
!> ä¸å¤§äº
!< ä¸å°äº
ä¾ï¼è¿å96å¹´1æçå®å
SELECT OrderID, CustomerID, OrderDate
FROM Orders
WHERE OrderDate>#1/1/96# AND OrderDate<#1/30/96#
注æï¼
Mcirosoft JET SQL ä¸ï¼æ¥æç¨â#âå®çãæ¥æä¹å¯ä»¥ç¨Datevalue()å½æ°æ¥ä»£æ¿ãå¨æ¯è¾å符åçæ°æ®æ¶ï¼è¦å ä¸åå¼å·ââï¼å°¾ç©ºæ ¼å¨æ¯è¾ä¸è¢«å¿½ç¥ã
ä¾ï¼
WHERE OrderDate>#96-1-1#
ä¹å¯ä»¥è¡¨ç¤ºä¸ºï¼
WHERE OrderDate>Datevalue(â1/1/96â)
ä½¿ç¨ NOT 表达å¼æ±åã
ä¾ï¼æ¥ç96å¹´1æ1æ¥ä»¥åçå®å
WHERE Not OrderDate<=#1/1/96#
2 èå´ï¼BETWEEN å NOT BETWEENï¼
BETWEEN â¦ANDâ¦è¿ç®ç¬¦æå®äºè¦æç´¢çä¸ä¸ªéåºé´ã
ä¾ï¼è¿å96å¹´1æå°96å¹´2æçå®åã
WHERE OrderDate Between #1/1/96# And #2/1/96#
3 å表ï¼IN ï¼NOT INï¼
IN è¿ç®ç¬¦ç¨æ¥å¹é
å表ä¸çä»»ä½ä¸ä¸ªå¼ãINåå¥å¯ä»¥ä»£æ¿ç¨ORåå¥è¿æ¥çä¸è¿ä¸²çæ¡ä»¶ã
ä¾ï¼è¦æ¾åºä½å¨ LondonãParisæBerlinçææ客æ·
SELECT CustomerID, CompanyName, ContactName, City
FROM Customers
WHERE City In(âLondonâ,â Parisâ,â Berlinâ)
4 模å¼å¹é
(LIKE)
LIKEè¿ç®ç¬¦æ£éªä¸ä¸ªå
å«å符串æ°æ®çå段å¼æ¯å¦å¹é
ä¸æå®æ¨¡å¼ã
LIKEè¿ç®ç¬¦é使ç¨çéé
符
éé
符 å«ä¹
ï¼ ä»»ä½ä¸ä¸ªåä¸çå符
* ä»»æé¿åº¦çå符
# 0~9ä¹é´çåä¸æ°å
[å符å表] å¨å符å表éçä»»ä¸å¼
[ï¼å符å表] ä¸å¨å符å表éçä»»ä¸å¼
- æå®å符èå´ï¼ä¸¤è¾¹çå¼åå«ä¸ºå
¶ä¸ä¸é
ä¾ï¼è¿åé®æ¿ç¼ç å¨ï¼171ï¼555-0000å°ï¼171ï¼555-9999ä¹é´ç客æ·
SELECT CustomerID ,CompanyName,City,Phone
FROM Customers
WHERE Phone Like â(171)555-####â
LIKEè¿ç®ç¬¦çä¸äºæ ·å¼åå«ä¹
æ ·å¼ å«ä¹ ä¸ç¬¦å
LIKE âA*â Aåè·ä»»æé¿åº¦çå符 Bc,c255
LIKEâ5[*]â 5*5 555
LIKEâ5?5â 5ä¸5ä¹é´æä»»æä¸ä¸ªå符 55,5wer5
LIKEâ5##5â 5235ï¼5005 5kd5,5346
LIKEâ[a-z]â a-zé´çä»»æä¸ä¸ªå符 5,%
LIKEâ[!0-9]â é0-9é´çä»»æä¸ä¸ªå符 0,1
LIKEâ[[]â 1,*
ä¸ .ç¨ORDER BYåå¥æåºç»æ
ORDERåå¥æä¸ä¸ªæå¤ä¸ªï¼æå¤16个ï¼å段æåºæ¥è¯¢ç»æï¼å¯ä»¥æ¯ååºï¼ASCï¼ä¹å¯ä»¥æ¯éåºï¼DESCï¼ï¼ç¼ºçæ¯ååºãORDERåå¥é常æ¾å¨SQLè¯å¥çæåã
ORDERåå¥ä¸å®ä¹äºå¤ä¸ªå段ï¼åæç
§å段çå
å顺åºæåºã
ä¾ï¼
SELECT ProductName,UnitPrice, UnitInStock
FROM Products
ORDER BY UnitInStock DESC , UnitPrice DESC, ProductName
ORDER BY åå¥ä¸å¯ä»¥ç¨å段å¨éæ©å表ä¸çä½ç½®å·ä»£æ¿å段åï¼å¯ä»¥æ··åå段ååä½ç½®å·ã
ä¾ï¼ä¸é¢çè¯å¥äº§çä¸ä¸åç¸åçææã
SELECT ProductName,UnitPrice, UnitInStock
FROM Products
ORDER BY 1 DESC , 2 DESC,3
å .è¿ç¨è¿æ¥å
³ç³»å®ç°å¤è¡¨æ¥è¯¢
ä¾ï¼æ¾åºåä¸ä¸ªåå¸ä¸ä¾åºåå客æ·çåå
SELECT Customers.CompanyName, Suppliers.ComPany.Name
FROM Customers, Suppliers
WHERE Customers.City=Suppliers.City
ä¾ï¼æ¾åºäº§ååºåé大äºåä¸ç§äº§åçå®åçæ°éç产ååå®å
SELECT ProductName,OrderID, UnitInStock, Quantity
FROM Products, [Order Deails]
WHERE Product.productID=[Order Details].ProductID
AND UnitsInStock>Quantity
å¦ä¸ç§æ¹æ³æ¯ç¨ Microsof JET SQL ç¬æç JNNER JOIN
è¯æ³ï¼
FROM table1 INNER JOIN table2
ON table1.field1 comparision table2.field2
å
¶ä¸comparision å°±æ¯åé¢WHEREåå¥ç¨å°çæ¯è¾è¿ç®ç¬¦ã
SELECT FirstName,lastName,OrderID,CustomerID,OrderDate
FROM Employees
INNER JOIN Orders ON Employees.EmployeeID=Orders.EmployeeID
注æï¼
INNER JOINä¸è½è¿æ¥Memo OLE Object Single Double æ°æ®ç±»åå段ã
å¨ä¸ä¸ªJOINè¯å¥ä¸è¿æ¥å¤ä¸ªONåå¥
è¯æ³ï¼
SELECT fields
FROM table1 INNER JOIN table2
ON table1.field1 compopr table2.field1 AND
ON table1.field2 compopr table2.field2 OR
ON table1.field3 compopr table2.field3
ä¹å¯ä»¥
SELECT fields
FROM table1 INNER JOIN
ï¼table2 INNER JOIN [( ]table3
[INNER JOER] [( ]tablex[INNER JOIN]
ON table1.field1 compopr table2.field1
ON table1.field2 compopr table2.field2
ON table1.field3 compopr table2.field3
å¤é¨è¿æ¥è¿åæ´å¤è®°å½ï¼å¨ç»æä¸ä¿çä¸å¹é
çè®°å½ï¼ä¸ç®¡åä¸åå¨æ»¡è¶³æ¡ä»¶çè®°å½é½è¦è¿åå¦ä¸ä¾§çææè®°å½ã
FROM table [LEFT|RIGHT]JOIN table2
ON table1.field1comparision table.field2
ç¨å·¦è¿æ¥æ¥å»ºç«å¤é¨è¿æ¥ï¼å¨è¡¨è¾¾å¼ç左边ç表ä¼æ¾ç¤ºå
¶ææçæ°æ®
ä¾ï¼ä¸ç®¡æ没æå®è´§éï¼è¿åææåå
SELECT ProductName ,OrderID
FROM Products
LEFT JOIN Orders ON Products.PrductsID=Orders.ProductID
å³è¿æ¥ä¸å·¦è¿æ¥çå·®å«å¨äºï¼ä¸ç®¡å·¦ä¾§è¡¨éæ没æå¹é
çè®°å½ï¼å®é½ä»å·¦ä¾§è¡¨ä¸è¿åææè®°å½ã
ä¾ï¼å¦ææ³äºè§£å®¢æ·çä¿¡æ¯ï¼å¹¶ç»è®¡å个å°åºç客æ·åå¸ï¼è¿æ¶å¯ä»¥ç¨ä¸ä¸ªå³è¿æ¥ï¼å³ä½¿æ个å°åºæ²¡æ客æ·ï¼ä¹è¦è¿å客æ·ä¿¡æ¯ã
空å¼ä¸ä¼ç¸äºå¹é
ï¼å¯ä»¥éè¿å¤è¿æ¥æè½æµè¯è¢«è¿æ¥çæ个表çå段æ¯å¦æ空å¼ã
SELECT *
FROM talbe1
LEFT JOIN table2 ON table1.a=table2.c
1 è¿æ¥æ¥è¯¢ä¸ä½¿ç¨Iifå½æ°å®ç°ä»¥0å¼æ¾ç¤ºç©ºå¼
Iif表达å¼ï¼ Iif(IsNull(Amount,0,Amout)
ä¾ï¼æ 论å®è´§å¤§äºæå°äºï¿¥50ï¼é½è¦è¿åä¸ä¸ªæ å¿ã
Iif([Amount]>50,?Big order?,?Small order?)
äº. åç»åæ»ç»æ¥è¯¢ç»æ
å¨SQLçè¯æ³éï¼GROUP BYåHAVINGåå¥ç¨æ¥å¯¹æ°æ®è¿è¡æ±æ»ãGROUP BYåå¥ææäºæç
§åªå 个å段æ¥åç»ï¼èå°è®°å½åç»åï¼ç¨HAVINGåå¥è¿æ»¤è¿äºè®°å½ã
GROUP BY åå¥çè¯æ³
SELECT fidldlist
FROM table
WHERE criteria
[GROUP BY groupfieldlist [HAVING groupcriteria]]
注ï¼Microsoft Jetæ°æ®åº Jet ä¸è½å¯¹å¤æ³¨æOLE对象å段åç»ã
GROUP BYå段ä¸çNullå¼ä»¥å¤åç»ä½æ¯ä¸è½è¢«çç¥ã
å¨ä»»ä½SQLå计å½æ°ä¸ä¸è®¡ç®Nullå¼ã
GROUP BYåå¥åæå¤å¯ä»¥å¸¦æå个å段ï¼æåºä¼å
级æä»å·¦å°å³ç顺åºæåã
ä¾ï¼å¨âWAâå°åºçéå表ä¸æ头è¡åç»åï¼æ¾åºå
·æåç头è¡çéåæ°ç®å¤§äº1人çææ头è¡ã
SELECT Title ,Count(Title) as Total
FROM Employees
WHERE Region = âWAâ
GROUP BY Title
HAVING Count(Title)>1
JET SQL ä¸çè积å½æ°
èéå½æ° æä¹
SUM ( ) æ±å
AVG ( ) å¹³åå¼
COUNT ( ) 表达å¼ä¸è®°å½çæ°ç®
COUNT (* ) 计ç®è®°å½çæ°ç®
MAX æ大å¼
MIN æå°å¼
VAR æ¹å·®
STDEV æ å误差
FIRST 第ä¸ä¸ªå¼
LAST æåä¸ä¸ªå¼
å
. ç¨Parameters声æå建åæ°æ¥è¯¢
Parameters声æçè¯æ³:
PARAMETERS name datatype[,name datatype[, â¦]]
å
¶ä¸name æ¯åæ°çæ å¿ç¬¦,å¯ä»¥éè¿æ å¿ç¬¦å¼ç¨åæ°.
Datatype说æåæ°çæ°æ®ç±»å.
使ç¨æ¶è¦æPARAMETERS 声æç½®äºä»»ä½å
¶ä»è¯å¥ä¹å.
ä¾:
PARAMETERS[Low price] Currency,[Beginning date]datatime
SELECT OrderID ,OrderAmount
FROM Orders
WHERE OrderAMount>[low price]
AND OrderDate>=[Beginning date]
ä¸. åè½æ¥è¯¢
æè°åè½æ¥è¯¢,å®é
ä¸æ¯ä¸ç§æä½æ¥è¯¢,å®å¯ä»¥å¯¹æ°æ®åºè¿è¡å¿«éé«æçæä½.å®ä»¥éæ©æ¥è¯¢ä¸ºç®ç,æéåºç¬¦åæ¡ä»¶çæ°æ®,å对æ°æ®è¿è¡æ¹å¤ç.åè½æ¥è¯¢å
æ¬æ´æ°æ¥è¯¢,å é¤æ¥è¯¢,æ·»å æ¥è¯¢,åçæ表æ¥è¯¢.
1 æ´æ°æ¥è¯¢
UPDATEåå¥å¯ä»¥åæ¶æ´æ¹ä¸ä¸ªæå¤ä¸ªè¡¨ä¸çæ°æ®.å®ä¹å¯ä»¥åæ¶æ´æ¹å¤ä¸ªå段çå¼.
æ´æ°æ¥è¯¢è¯æ³:
UPDATE 表å
SET æ°å¼
WHERE åå
ä¾:è±å½å®¢æ·çå®è´§éå¢å 5%,è´§è¿éå¢å 3%
UPDATE OEDERS
SET OrderAmount = OrderAmount *1.1
Freight = Freight*1.03
WHERE ShipCountry = âUKâ
2 å é¤æ¥è¯¢
DELETEåå¥å¯ä»¥ä½¿ç¨æ·å é¤å¤§éçè¿æ¶çæåäºçæ°æ®.
注:å é¤æ¥è¯¢ç对象æ¯æ´ä¸ªè®°å½.
DELETEåå¥çè¯æ³:
DELETE [表å.*]
FROM æ¥æºè¡¨
WHERE åå
ä¾: è¦å é¤ææ94å¹´åçå®å
DELETE *
FROM Orders
WHERE OrderData<#94-1-1#
3 追å æ¥è¯¢
INSERTåå¥å¯ä»¥å°ä¸ä¸ªæä¸ç»è®°å½è¿½å å°ä¸ä¸ªæå¤ä¸ªè¡¨çå°¾é¨.
INTO åå¥æå®æ¥åæ°è®°å½ç表
valueS å
³é®åæå®æ°è®°å½æå
å«çæ°æ®å¼.
INSERT åå¥çè¯æ³:
INSETR INTO ç®ç表ææ¥è¯¢(å段1,å段2,â¦)
valueS(æ°å¼1,æ°å¼2,â¦)
ä¾:å¢å ä¸ä¸ªå®¢æ·
INSERT INTO Employees(FirstName,LastName,title)
valueS(âHarryâ,âWashingtonâ,âTraineeâ)
4 çæ表æ¥è¯¢
å¯ä»¥ä¸æ¬¡æ§å°æææ满足æ¡ä»¶çè®°å½æ·è´å°ä¸å¼ æ°è¡¨ä¸.é常å¶ä½è®°å½çå¤ä»½æå¯æ¬æä½ä¸ºæ¥è¡¨çåºç¡.
SELECT INTOåå¥ç¨æ¥å建çæ表æ¥è¯¢è¯æ³:
SELECT å段1,å段2,â¦
INTO æ°è¡¨[IN å¤é¨æ°æ®åº]
FROM æ¥æºæ°æ®åº
WHERE åå
ä¾:为å®åå¶ä½ä¸ä¸ªåæ¡£å¤ä»½
SELECT *
INTO OrdersArchive
FROM Orders
å
«. èåæ¥è¯¢
UNIONè¿ç®å¯ä»¥æå¤ä¸ªæ¥è¯¢çç»æå并å°ä¸ä¸ªç»æééæ¾ç¤º.
UNIONè¿ç®çä¸è¬è¯æ³:
[表]æ¥è¯¢1 UNION [ALL]æ¥è¯¢2 UNION â¦
ä¾:è¿å巴西ææä¾ç»åå客æ·çååååå¸
SELECT CompanyName,City
FROM Suppliers
WHERE Country = âBrazilâ
UNION
SELECT CompanyName,City
FROM Customers
WHERE Country = âBrazilâ
注:
缺ççæ
åµä¸,UNIONåå¥ä¸è¿åéå¤çè®°å½.å¦ææ³æ¾ç¤ºææè®°å½,å¯ä»¥å ALLé项
UNIONè¿ç®è¦æ±æ¥è¯¢å
·æç¸åæ°ç®çå段.ä½æ¯,å段æ°æ®ç±»åä¸å¿
ç¸å.
æ¯ä¸ä¸ªæ¥è¯¢åæ°ä¸å¯ä»¥ä½¿ç¨GROUP BY åå¥ æ HAVING åå¥è¿è¡åç».è¦æ³ä»¥æå®ç顺åºæ¥æ¾ç¤ºè¿åçæ°æ®,å¯ä»¥å¨æåä¸ä¸ªæ¥è¯¢çå°¾é¨ä½¿ç¨OREER BYåå¥.
ä¹. 交åæ¥è¯¢
交åæ¥è¯¢å¯ä»¥å¯¹æ°æ®è¿è¡æ»å,å¹³å,计æ°æå
¶ä»æ»å计ç®æ³ç计ç®,è¿äºæ°æ®éè¿ä¸¤ç§ä¿¡æ¯è¿è¡åç»:ä¸ä¸ªæ¾ç¤ºå¨è¡¨çå·¦é¨,å¦ä¸ä¸ªæ¾ç¤ºå¨è¡¨ç顶é¨.
Microsoft Jet SQL ç¨TRANSFROMè¯å¥å建交å表æ¥è¯¢è¯æ³:
TRANSFORM aggfunction
SELECT è¯å¥
GROUP BY åå¥
PIVOT pivotfield[IN(value1 [,value2[,â¦]]) ]
AggfounctionæSQLè积å½æ°,
SELECTè¯å¥éæ©ä½ä¸ºæ é¢ççå段,
GROUP BY åç»
说æï¼
Pivotfield å¨æ¥è¯¢ç»æéä¸å建åæ é¢æ¶ç¨çå段æ表达å¼,ç¨å¯éçINåå¥éå¶å®çåå¼.
value代表å建åæ é¢çåºå®å¼.
ä¾:æ¾ç¤ºå¨1996å¹´éæ¯ä¸å£åº¦æ¯ä¸ä½åå·¥ææ¥çå®åçæ°ç®:
TRANSFORM Count(OrderID)
SELECT FirstName&ââ&LastName AS FullName
FROM Employees INNER JOIN Orders
ON Employees.EmployeeID = Orders.EmployeeID
WHERE DatePart(âyyyyâ,OrderDate)= â1996â
GROUP BY FirstName&ââ&LastName
ORDER BY FirstName&ââ&LastName
POVOT DatePart(âqâ,OrderDate)&âå£åº¦â
å .åæ¥è¯¢
åæ¥è¯¢å¯ä»¥ç解为 å¥æ¥è¯¢.åæ¥è¯¢æ¯ä¸ä¸ªSELECTè¯å¥.
1 表达å¼çå¼ä¸åæ¥è¯¢è¿åçåä¸å¼åæ¯è¾
è¯æ³:
è¡¨è¾¾å¼ comparision [ANY|ALL|SOME](åæ¥è¯¢)
说æï¼
ANYåSOMEè°è¯æ¯åä¹è¯,ä¸æ¯è¾è¿ç®ç¬¦(=,<,>,<>,<=,>=)ä¸èµ·ä½¿ç¨.è¿åä¸ä¸ªå¸å°å¼TrueæFalse.ANYçæææ¯,表达å¼ä¸åæ¥è¯¢è¿åçä¸ç³»åçå¼éä¸æ¯è¾,åªè¦å
¶ä¸çä¸æ¬¡æ¯è¾äº§çTrueç»æ,ANYæµè¯çè¿å Trueå¼(æ¢WHEREåå¥çç»æ),对åºäºè¯¥è¡¨è¾¾å¼çå½åè®°å½å°è¿å
¥ä¸»æ¥è¯¢çç»æä¸.ALLæµè¯åè¦æ±è¡¨è¾¾å¼ä¸åæ¥è¯¢è¿åçä¸ç³»åçå¼çæ¯è¾é½äº§çTrueç»æ,æåè¿åTrueå¼.
ä¾:主æ¥è¯¢è¿ååä»·æ¯ä»»ä½ä¸ä¸ªææ£å¤§äºçäº25%ç产åçåä»·è¦é«çææ产å
SELECT * FROM Products
WHERE UnitPrice>ANY
(SELECT UnitPrice FROM[Order Details] WHERE Discount>0.25)
2 æ£æ¥è¡¨è¾¾å¼çå¼æ¯å¦å¹é
åæ¥è¯¢è¿åçä¸ç»å¼çæ个å¼
è¯æ³:
[NOT]IN(åæ¥è¯¢)
ä¾:è¿ååºåä»·å¼å¤§äºçäº1000ç产å.
SELECT ProductName FROM Products
WHERE ProductID IN
(SELECT PrdoctID FROM [Order DEtails]
WHERE UnitPrice*Quantity>= 1000)
3æ£æµåæ¥è¯¢æ¯å¦è¿åä»»ä½è®°å½
è¯æ³:
[NOT]EXISTS (åæ¥è¯¢)
ä¾:ç¨EXISTSæ£ç´¢è±å½ç客æ·
SELECT ComPanyName,ContactName
FROM Orders
WHERE EXISTS
(SELECT *
FROM Customers
WHERE Country = âUKâ AND
Customers.CustomerID= Orders.CustomerID)
温馨提示:答案为网友推荐,仅供参考