复杂组合查询

1. bool 查询

select * from apple where (provider='苹果' and minPrice>=5000) or productCode=404

2. range

select * from apple where minPrice range in (1,3];
select * from apple where minPrice >1 or minPrice <=3;