/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

28 votes238 views6 answers
Sql update
SQL
4 votes229 views1 answer
Search column by name mysql
SQL
0 vote215 views2 answers
Csv into data postgres
SQL
6 votes215 views2 answers
Mysql first day of month
SQL
0 vote224 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
5 votes246 views2 answers
Postgresql add not null constraint
SQL
20 votes236 views3 answers
How to open postgresql in mac
SQL
1 vote209 views1 answer
Postgres format date in select
SQL
1 vote230 views1 answer
Mysql datetime with timezone offset
SQL
1 vote224 views1 answer
Where database run
SQL