/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 vote303 views1 answer
Mysql table variables
SQL
1 vote252 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote316 views3 answers
Postgresql grant alter table to user
SQL
0 vote311 views1 answer
Django mssql backend
SQL
0 vote321 views1 answer
T-SQL Create Trigger
SQL
0 vote264 views1 answer
Flask_sqlalchemy install
SQL
1 vote306 views2 answers
Last working day in week date function in sql
SQL
1 vote319 views1 answer
How to test for sql injection
SQL
6 votes334 views2 answers
Mysql execute file
SQL
6 votes309 views4 answers
Delete table sqlite
SQL