/SQL/How to fetch highest score in minimum time using mysql

How to fetch highest score in minimum time using mysql

SELECT gameid, 
       MIN(date) AS FirstTime, 
       MAX(date) AS LastTime,
       MAX(score) AS TOPscore.
       COUNT(*)  AS NbOfTimesPlayed 
FROM highscores
WHERE userid='2345' 
GROUP BY gameid
-- ORDER BY COUNT(*) DESC -- for ex. to have games played most at top

Source: stackoverflow.com

Similar codes

1 vote138 views1 answer
Alter constraint in sql
SQL
11 votes135 views2 answers
Safe mode off mysql
SQL
0 vote133 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
7 votes121 views3 answers
Sql update where id
SQL
1 vote122 views1 answer
Get rows affected mysql python
SQL
0 vote87 views1 answer
Mysql workbench search all tables
SQL
0 vote142 views1 answer
TSQL convert csv to table
SQL
16 votes131 views2 answers
Add column if not exists mysql
SQL
1 vote125 views1 answer
Mariadb case switch
SQL
1 vote151 views1 answer
Sql server set variable if exists
SQL