![]() ![]() If we want to display the list of employees with columns empno, emp_first_name, emp_last_name and designation from employee table who does not belong to the designation 'CLERCK' and 'SALESMAN', the following SQL can be used. PostgreSQL Greater Than or Equal( >= ) and Less Than or Equal( ='' I've been working on it for awhile and although it started out small it just kept growing :) You find everything you need to create an anchor chart to use as a teaching tool and hang in your classroom for reference. If we want to display the list of employees with columns empno, emp_first_name,designame and salary from an employee who drawn the salary amount more than 18000, the following SQL can be used.Ĭode: SELECT empno,emp_first_name,designame,salary Greater Than, Less Than, Equal To I am super, duper excited about my newest learning pack. PostgreSQL Less Than ( ) operator example Returns true when the operands are not equal. Returns true when the operands are equal but the type of the operands must be same. ![]() Returns true when the left operand is greater than or equal to the right operand.
0 Comments
Leave a Reply. |