單項選擇題

取出工資在2000到3000元(包括上下限)之間的員工()

A.select * from emp wher sal in (2000,3000);
B.select * from emp wher sal like (2000,3000);
C.select * from emp wher sal = (2000,3000);
D.select * from emp wher sal between 2000 and 3000;

微信掃碼免費搜題