/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

0 vote134 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote145 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote131 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote137 views1 answer
Oracle create program if no exists
SQL
0 vote88 views1 answer
Oracle list all stored procedures
SQL
2 votes137 views1 answer
Postgresql add entry to table
SQL
0 vote142 views1 answer
Multiple tricky query in sql server
SQL
13 votes126 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
9 votes131 views2 answers
Cmd to rename a collumn name in sql
SQL
3 votes132 views2 answers
Sql paging query
SQL