/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

1 vote265 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote210 views1 answer
Oracle boolean to varchar
SQL
0 vote317 views1 answer
Mysl like insert a variable
SQL
5 votes269 views5 answers
Find max number in sql
SQL
0 vote268 views1 answer
How to add timestamp column in mysql
SQL
0 vote244 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote238 views1 answer
Oracle sql date summer time
SQL
0 vote244 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
7 votes273 views5 answers
Oracle alter table
SQL
0 vote274 views1 answer
Search from comma separated values in sql server
SQL