读书人

关于select in的有关问题

发布时间: 2012-01-09 21:05:42 作者: rapoo

关于select in的问题
我写了如下的两条SQL语句:
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID1, ID2')

SELECT count(*) FROM Topics WHERE AND SectionID in ('ID2, ID1')
按理说,两条语句执行结果应该是一样的,但是结果不一样

SELECT count(*) FROM Topics WHERE AND SectionID in ('ID1, ID2')的结果和
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID1')一样

SELECT count(*) FROM Topics WHERE AND SectionID in ('ID2, ID1')的结果和
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID2')一样

不太明白为什么,请大家解释一下



[解决办法]
法是:
SELECT count(*) FROM Topics WHERE AND SectionID in ( 'ID1', 'ID2')

读书人网 >SQL Server

热点推荐