select * from [tablename] where (price>=100 and price<=199) or(price>=200 and price<=299) or(price>=300 and price<=399) 是这意思吗?
