How to get maximum value in sqlite with username?

Question

Python

please help me

cursor.execute("SELECT MAX(ochki) FROM db")
all_db = cursor.fetchall()

I am outputting max points and I want to enter the player's name along with those points

. How do I do this?

Answer 1

Not the fact that this line is the only one ... Therefore, something like this:

SELECT * FROM db WHERE ochki=(select max(ochki) from db)

Answer 2

Try this code:
SELECT * FROM db LIMIT 1;