已知员工表emp(empno,ename,job,sal,comm,deptno)其中empno员工编号,ename员工姓名,job员工的职位,sal员工的工资,comm奖金,deptno员工所在部门编号。查询工资在2500和4000之间(包括2500和4000)的员工姓名,工资和奖金,正确的sql语句是()
A. select ename,sal,comm from emp where sal>=2500 or sal<=4000;
B. select ename,sal,comm from emp where sal>=2500 and salz<=4000;
C. select ename,sal,comm from emp where sal between 2500 or 4000;
D. select ename,sal,comm from emp where sal between 2500 and 4000;