# 查询是800或5000的工资的人select * from emp where SAL in(800,5000);
# 查询薪资在800到1000之间的人select * from emp where SAL between 800 and 5000;