/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 vote318 views1 answer
How to create notes in mysql
SQL
8 votes285 views1 answer
Mysql restore database
SQL
0 vote305 views1 answer
Shortcut run sql pgadmin
SQL
0 vote299 views1 answer
Mysql subdate
SQL
0 vote287 views1 answer
Postgresql print variable
SQL
-1 vote279 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote292 views2 answers
Update query with between in mysql
SQL
1 vote253 views1 answer
Enable mysql slow query log
SQL
0 vote277 views1 answer
Oracle drop default value
SQL
0 vote270 views1 answer
Select other columns with distinct
SQL