/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

1 vote233 views2 answers
Update with inner join sql server
SQL
0 vote227 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote237 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote235 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
1 vote387 views3 answers
Sql subquery
SQL
2 votes236 views2 answers
Checking data type in sql server
SQL
16 votes244 views3 answers
Tsql rename column name
SQL
3 votes229 views2 answers
Sqlite show table definition
SQL
2 votes253 views1 answer
Sqlite3 show columns name
SQL
2 votes276 views1 answer
Datefromparts mssql
SQL