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 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 | | 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()
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics