w3resource

MySQL greater than operator

greater than operator

MySQL greater than operator checks whether an expression is greater than another expression.

Syntax:

>

MySQL Version: 8.0

Example: MySQL greater than operator

The following MySQL statement will fetch those publishers from the publisher table who have more than 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 Expression: MySQL greater than operator.

Relational Algebra Tree:

Relational Algebra Tree: MySQL greater than operator.

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 | 
| Mountain Publication | USA     | Houstan  |           25 | 
+----------------------+---------+----------+--------------+
2 rows in set (0.00 sec)

Slideshow of MySQL Comparison Function and Operators

Previous: Greater than or equal operator(>=)
Next: GREATEST()



Follow us on Facebook and Twitter for latest update.