/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

15 votes178 views2 answers
How to know the username of postgresql
SQL
0 vote172 views1 answer
Sql replace id with name from another table
SQL
0 vote157 views2 answers
How to start postgresql laravel
SQL
1 vote180 views1 answer
Mysql count all table rows
SQL
0 vote242 views1 answer
Get enginge db mysql
SQL
8 votes167 views1 answer
Oracle add months to sysdate
SQL
0 vote167 views1 answer
SQL column name Oracle
SQL
0 vote180 views1 answer
Increase speed of like queries postgres
SQL
0 vote212 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote256 views1 answer
Create new table from old table with data
SQL