/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 vote219 views1 answer
How to access to mysql without root
SQL
2 votes353 views1 answer
How to create sql database
SQL
0 vote187 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote189 views1 answer
Sql server cannot create database diagram
SQL
0 vote205 views1 answer
How to get one year old query from plan cache
SQL
0 vote198 views2 answers
Sql server select where date
SQL
0 vote190 views1 answer
How to print out column name differently in mysql
SQL
0 vote197 views1 answer
Mysql two joins
SQL
0 vote157 views1 answer
Mysql collation for all languages
SQL
0 vote231 views1 answer
Psql store procedure-return multiple table values
SQL