w3resource logo


postgresql Comparison Operators

PostgreSQL Comparison Operators

Secondary Nav

Description

Comparison operators, as their name, allows to compare two values. It Compares strings or numbers for relationships such as equality.

List of Comparison Operators

Operators Description
< ( less than) Returns true when the left operand is less than the right operand.
> ( greater than) Returns true when the left operand is greater than the right operand.
<= ( less than or equal ) Returns true when the left operand is less than or equal to the right operand.
>= (greater than or equal) Returns true when the left operand is greater than or equal to the right operand.
= ( equal ) Returns true when the operands are equal but the type of the operands must be same.
<> or != ( not equal) Returns true when the operands are not equal.

The sample table

postgresql sample table employee example1

PostgreSQL Less Than ( < ) operator example

If we want to display the list of employees with columns empno, emp_first_name, designame and salary from employee who drawn the salary amount less than 10000, the following SQL can be used.

SQL


SELECT empno,emp_first_name,designame,salary

FROM employee

WHERE salary<10000;

              

Output

postgresql less than operator

PostgreSQL Greater Than ( > ) operator example

If we want to display the list of employees with columns empno, emp_first_name,designame and salary from employee who drawn the salary amount more than 18000, the following SQL can be used.

SQL


SELECT empno,emp_first_name,designame,salary

FROM employee

WHERE salary>18000;

              

Output

postgresql greater than operator

PostgreSQL Greater Than or Equal( >= ) and Less Than or Equal( <= ) operator example

If we want to display the list of employees with columns empno, emp_first_name, emp_last_name,designame and dt_birth from employee who born between the period 1975-01-01 and 1982-03-31, the following SQL can be used.

SQL


SELECT empno,emp_first_name,emp_last_name,designame,dt_birth

FROM employee

WHERE  dt_birth>='1975-01-01'

AND dt_birth<='1982-03-31';

              

Output

postgresql greater than equla and less than equal operator

PostgreSQL Equal ( = ) operator example

If we want to display the list of employees with columns empno, emp_first_name, emp_last_name and designation from employee table whose designation is 'CLERCK', the following SQL can be used. .

SQL


SELECT empno,emp_first_name,emp_last_name,designame

FROM employee

WHERE  designame='CLERCK';

              

Output

postgresql equal operator

PostgreSQL Not Equal (<> or != ) operator example

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 belongs to the designation 'CLERCK' and 'SALESMAN', the following SQL can be used. .

SQL


SELECT empno,emp_first_name,emp_last_name,designame

FROM employee

WHERE  designame<>'CLERCK'

AND designame<>'SALESMAN';

              

Output

postgresql not equal operator



Is this content useful for you?

 


You might be using Adblocker. Since w3resource does not charge anything from users, all of our expenses (e.g. Hosting, Content Creation, Development etc.) are met by advertisement. Please whitelist w3resource.