Question

select grade from salgrade where sal in （select sal from emp where deptno＝(select deptno fro

select grade from salgrade where sal in （select sal from emp where deptno＝(select deptno from emp where ename='smith')) between losal and hisal;请问这句为什么提示sql命令未正确结束？我检查了好多遍语法和逻辑并没有错啊

Answer 1

between 的语法前面应该加列名，不能和in共用吧。

参考资料：
http://www.w3school.com.cn/sql/sql_between.asp