个人资料
最新文章
文章分类
归档
博文
(2006-06-09 22:12:48)
TheINoperatormaybeusedifyouknowtheexactvalueyouwanttoreturnforatleastoneofthecolumns.TodisplaythepersonswithLastNameequalto"Hansen"or"Pettersen",usethefollowingSQL:
SELECT*FROMPersonsWHERELastNameIN('Hansen','Pettersen')
TheBETWEEN...ANDoperatorselectsarangeofdatabetweentwovalues.Todisplaythepersonsalphabeticallybetween(including)"Hansen"andexclusive"Pettersen",usethefollowingSQL:
SELE...[阅读全文]
阅读 ()评论 (1)