select [a],[b],[c],[d],[e] from where [id]=1 or [id]=2 or [id]=3 or [id]=4 or [id]=5 or [id]=6 or [id]=7 or [id]=8 or [id]=9 or ............ [id]=200
这名SQL效率如何
------解决方案--------------------------------------------------------
where [id]<200
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
- SQL code
select [a],[b],[c],[d],[e] from where [id]<=200
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
就没有你那么写的。。
------解决方案--------------------------------------------------------
where id in (1,2,3....)