MYSQL查询金币最多的玩家和金币最少的玩家及其金币数
时间: 2024-03-27 16:35:11 浏览: 24
好的,这个问题很简单,你可以使用以下的SQL语句查询:
```
SELECT
MAX(gold) AS max_gold,
MIN(gold) AS min_gold,
(SELECT player_name FROM player WHERE gold = (SELECT MAX(gold) FROM player)) AS max_gold_player,
(SELECT player_name FROM player WHERE gold = (SELECT MIN(gold) FROM player)) AS min_gold_player
FROM
player;
```
这个查询会返回四列结果,分别是金币最多的玩家的金币数、金币最少的玩家的金币数、金币最多的玩家的名字和金币最少的玩家的名字。你可以根据自己的需要调整查询语句。
阅读全文