Question

sql="select BigClassName from BigClass_New where BigClassID=6" 如果我想调用id6,10,11该怎么写啊

sql="select BigClassName from BigClass_New where BigClassID=6" 如果我想调用id6,10,11该怎么写啊
BigClassID='6,10,11'这样不行啊 希望高手提示一下

Answer 1

select BigClassName from BigClass_New
where BigClassID IN ('6','10','11')
试试这个

Answer 2

sql="select BigClassName from BigClass_New where BigClassID in ('6','10','11')

追问

试了一下好像不行呢

追答

怎么不行？报错吗？

追问

是的啊用范围可以

追答

in肯定是没问题的，估计你那里写错了，实在不行就写成where bigclassid ='6' or bigclassid='10' or bigclassid='11'

追问

or可以 呵呵

Answer 3

select BigClassName from BigClass_New where BigClassID in '6,10,11' 这样呢

Answer 4

where BigClassID in ('6','10','11')