MySQL greater than or equal operator

greater than or equal operator

MySQL greater than or equal operator checks whether one expression is either greater than or equal to another expression.

Syntax:

>=

MySQL Version: 8.0

Example: MySQL greater than or equal operator

The following MySQL statement will fetch those publishers from the publisher table who have more than or equal to 10 branch offices.

Code:

SELECT pub_name,country,pub_city,no_of_branch       
FROM publisher           
WHERE no_of_branch>=10;

Relational Algebra Expression:

Relational Algebra Tree:

Sample table: publisher

Output:

mysql> SELECT pub_name,country,pub_city,no_of_branch       
    -> FROM publisher           
    -> WHERE no_of_branch>=10;
+--------------------------+---------+-----------+--------------+
| pub_name                 | country | pub_city  | no_of_branch |
+--------------------------+---------+-----------+--------------+
| Jex Max Publication      | USA     | New York  |           15 | 
| BPP Publication          | India   | Mumbai    |           10 | 
| Mountain Publication     | USA     | Houstan   |           25 | 
| Summer Night Publication | USA     | New York  |           10 | 
| Novel Publisher Ltd.     | India   | New Delhi |           10 | 
+--------------------------+---------+-----------+--------------+
5 rows in set (0.00 sec)

Slideshow of MySQL Comparison Function and Operators

Previous: Equal operator(=)
Next: Greater than operator(>)