/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 vote116 views1 answer
How to see the query of a view in mysql
SQL
1 vote111 views1 answer
Best sql course
SQL
13 votes130 views5 answers
Sql default
SQL
0 vote106 views1 answer
Sql string length postgresql
SQL
1 vote124 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
2 votes118 views1 answer
Sql update \
SQL
0 vote111 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote117 views1 answer
Take sql dump in to file
SQL
0 vote118 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote77 views1 answer
Online sql compiler
SQL