请教:select first_name,salary,grade from s_emp
where salary(+) between losal and hisal;和
select first_name,salary,grade from s_emp from s_emp
where salary between losal(+) and hisal(+);中,外连接符号用法的区别。还有,losal和hisal是什么?是宏?谢谢!
where salary(+) between losal and hisal;和
select first_name,salary,grade from s_emp from s_emp
where salary between losal(+) and hisal(+);中,外连接符号用法的区别。还有,losal和hisal是什么?是宏?谢谢!
salary和losal,hisal,如果是同一张表的不同字段的话,语句本身是有问题的;
另外,losal和hisal按字面理解应该是两个字段,分别是low salary和high salary