/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 vote139 views1 answer
Data type and their numeric form
SQL
6 votes134 views5 answers
Alter table oracle
SQL
0 vote238 views1 answer
Run mysql xampp shell
SQL
3 votes172 views2 answers
Find string in stored procedure sql server
SQL
7 votes138 views3 answers
How to check table name in current database sql
SQL
0 vote180 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote138 views1 answer
How to select random rows from table
SQL
0 vote142 views1 answer
Mysql timediff
SQL
0 vote136 views1 answer
Sql delete where x or y or z
SQL
0 vote151 views1 answer
How to join result table in mysql
SQL