TheINoperatormaybeusedifyouknowtheexactvalueyouwanttoreturnforatleastoneofthecolumns.TodisplaythepersonswithLastNameequalto"Hansen"or"Pettersen",usethefollowingSQL:
SELECT*FROMPersonsWHERELastNameIN('Hansen','Pettersen')
TheBETWEEN...ANDoperatorselectsarangeofdatabetweentwovalues.Todisplaythepersonsalphabeticallybetween(including)"Hansen"andexclusive"Pettersen",usethefollowingSQL:
SELE...[閱讀全文]
將漂泊進行到底
將漂泊進行到底
博文
(2006-06-09 22:12:48)
