/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 votes171 views2 answers
Postgres set user as superuser
SQL
0 vote137 views1 answer
Tsql cmd exec script from file
SQL
0 vote141 views1 answer
Get duplicate entry sql
SQL
0 vote96 views1 answer
Check id exist or not in sql
SQL
0 vote130 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote133 views1 answer
Sql delete row with auto increment
SQL
6 votes220 views1 answer
Sql insert values into table
SQL
1 vote163 views1 answer
Oracle activate job
SQL
2 votes129 views2 answers
Compare date mysql
SQL
4 votes171 views4 answers
Remove duplicate old value in mysql
SQL