SQL_LessThan_Operator
SELECT ename, sal , job from emp where sal > 2000 AND sal < 4000
Oracle
PostgreSQL