MySQL 如何在查询中写入不大于符号

查询中的不大于可以简单地像小于或等于 (< = )一样编写。语法如下−

select * from yourTableName where yourColumnName<=yourColumnName;

让我们首先创建一个表−

mysql> create table DemoTable1480
   -> (
   -> StudentName varchar(40),
   -> StudentMarks int
   -> );
Query OK, 0 rows affected (0.50 sec)

使用插入命令将一些记录插入表中−

mysql> insert into DemoTable1480 values('Chris',78);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable1480 values('Bob',45);
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable1480 values('John',67);
Query OK, 1 row affected (0.16 sec)
mysql> insert into DemoTable1480 values('Adam',56);
Query OK, 1 row affected (0.14 sec)

使用select语句显示表中的所有记录−

mysql> select * from DemoTable1480;

这将产生以下输出−

+-------------+--------------+
| StudentName | StudentMarks |
+-------------+--------------+
| Chris       |           78 |
| Bob         |           45 |
| John        |           67 |
| Adam        |           56 |
+-------------+--------------+
4 rows in set (0.00 sec)

以下是在MySQL查询中写不大于的查询−

mysql> select * from DemoTable1480 where StudentMarks <=65;

这将产生以下输出−

+-------------+--------------+
| StudentName | StudentMarks |
+-------------+--------------+
| Bob         |           45 |
| Adam        |           56 |
+-------------+--------------+
2 rows in set (0.00 sec)