本地SQL查询
我想查询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);
[解决办法]
楼主的也应该可以的吧。注意下类型