/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 vote303 views1 answer
Check if database exists sql
SQL
33 votes303 views6 answers
Change column name in mysql
SQL
0 vote319 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote298 views1 answer
How to select rows with no matching entry in another table?
SQL
4 votes301 views2 answers
Oracle sql group by date year
SQL
0 vote305 views1 answer
How to use group_concat in sql server
SQL
1 vote298 views1 answer
Sql select contem uma palavra
SQL
0 vote313 views1 answer
Materialized view redshift
SQL
18 votes293 views3 answers
Mysql number format
SQL
0 vote291 views1 answer
Sql server delete records with specific date
SQL