我想查询salary表的薪水是0到2000是下面的写法，在本地SQL查询中我想查所有的的是怎么写？要有between and.
select * from salary where price between 0 and 2000;
------解决方案--------------------
楼主指的本地SQL指的是什么?
用LZ的SQL指令不行吗
------解决方案--------------------
select * from salary ?不可以么
------解决方案--------------------
select * from salary where price is not null
------解决方案--------------------
select * from salary where price between 0 and (select max(paice) from salary);
------解决方案--------------------
楼主的也应该可以的吧。注意下类型