/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

2 votes360 views1 answer
Sql column values comma separated
SQL
1 vote381 views2 answers
Sql split string by space
SQL
1 vote378 views1 answer
Myql find duplicates
SQL
0 vote364 views1 answer
Mysql set column equal to another automatic
SQL
0 vote395 views2 answers
Get item by composite primary key mysql
SQL
4 votes362 views1 answer
Search column by name mysql
SQL
1 vote361 views1 answer
Rails run native ssql query
SQL
4 votes334 views1 answer
Update table from another table oracle
SQL
0 vote337 views1 answer
Alter precision
SQL
0 vote389 views1 answer
Login failed for user sql server
SQL