mysql 获取数学成绩最高以及最低的同学sql语句
- mysql> select * from test;
- +----+----------+-------+-----------+
- | id | name | score | subject |
- +----+----------+-------+-----------+
- | 1 | xiaoming | 89 | shuxue |
- | 2 | xiaohong | 89 | shuxue |
- | 3 | xiaohong | 80 | english |
- | 4 | xiaohong | 80 | physics |
- | 5 | xiaohong | 80 | astronaut |
- | 6 | xiaoming | 80 | physics |
- | 7 | xiaoming | 80 | astronaut |
- | 8 | xiaoming | 80 | english |
- | 9 | xiaobai | 80 | astronaut |
- | 10 | xiaobai | 80 | english |
- | 11 | xiaobai | 80 | physics |
- | 12 | xiaobai | 80 | shuxue |
- | 13 | xiaohei | 80 | astronaut |
- | 14 | xiaohei | 80 | shuxue |
- | 15 | xiaohei | 80 | physics |
- | 16 | xiaohei | 80 | english |
- +----+----------+-------+-----------+
- 16 rows in set (0.00 sec)
复制代码 成绩最高
- mysql> select name,score from test where subject='shuxue' order by score desc limit 1;
- +----------+-------+
- | name | score |
- +----------+-------+
- | xiaoming | 89 |
- +----------+-------+
- 1 row in set (0.00 sec)
复制代码 成绩最低
- mysql> select name,score from test where subject='shuxue' order by score limit 1;
- +---------+-------+
- | name | score |
- +---------+-------+
- | xiaohei | 80 |
- +---------+-------+
- 1 row in set (0.00 sec)
复制代码
|
|