/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 vote179 views1 answer
Ignore case in string sql
SQL
0 vote170 views1 answer
Find usage of table in sql server
SQL
0 vote169 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote215 views1 answer
Stop psql server windows
SQL
1 vote164 views1 answer
Delete triger pl pg sql
SQL
3 votes237 views2 answers
Brew restart mysql
SQL
1 vote241 views1 answer
Top 10 rows in mysql
SQL
5 votes188 views3 answers
Mysql check if null or empty string
SQL
0 vote198 views1 answer
Sql string contains case sensitive
SQL
1 vote173 views1 answer
Xampp import sql file command line
SQL