sqlite：断言语句：获取具有最高值的名称

Question

注意：请随时分享适用的资源。我发现这相当困难。我正在尝试编写以下 python 函数：def player_with_max_points_per_game():    """ The player with highest average points per game"""    cur.execute('SELECT name, avg_points FROM players ORDER BY     avg_points')    # Now I want to select 'name' from the top rowPS：我意识到我的预期方法可能效率低下。我看到有一个 MAX() 函数。有什么建议吗？

Answer 1

只需获取第一列的值。

cur.execute('SELECT name, avg_points FROM players ORDER BY avg_points DESC LIMIT 1')

row = cur.fetchone()

best_player_name = row[0]