TheINoperatormaybeusedifyouknowtheexactvalueyouwanttoreturnforatleastoneofthecolumns.TodisplaythepersonswithLastNameequalto"Hansen"or"Pettersen",usethefollowingSQL:
SELECT*FROMPersonsWHERELastNameIN('Hansen','Pettersen')
TheBETWEEN...ANDoperatorselectsarangeofdatabetweentwovalues.Todisplaythepersonsalphabeticallybetween(including)"Hansen"andexclusive"Pettersen",usethefollowingSQL:
SELE...[阅读全文]