/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 vote187 views1 answer
Pl/sql loop example
SQL
2 votes206 views1 answer
Column names in oracle sql
SQL
4 votes182 views2 answers
Oracle unliock account
SQL
0 vote214 views1 answer
See the structure of a table mysql
SQL
0 vote190 views1 answer
Find invalid datetime field
SQL
-1 vote195 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote236 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
1 vote197 views1 answer
Mysql best tutorial for beginners
SQL
10 votes199 views2 answers
Show tables in schema oracle
SQL
2 votes196 views1 answer
How to find table table in stored procedure sql server
SQL