mysql|mysql 获取数学成绩最高以及最低的同学 mysql获取数学成绩最高以及最低

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)

【mysql|mysql 获取数学成绩最高以及最低的同学】

转载于:https://www.cnblogs.com/sea-stream/p/11305852.html