/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 vote217 views1 answer
Sql current timestamp
SQL
6 votes196 views5 answers
Alter table oracle
SQL
1 vote284 views1 answer
Top 10 rows in mysql
SQL
1 vote213 views1 answer
Age postgres
SQL
0 vote198 views2 answers
Database owner can't create new tables postgres
SQL
0 vote219 views1 answer
Mysql pv progres
SQL
0 vote223 views1 answer
Postgresql inline table
SQL
0 vote200 views2 answers
How to tun mysql on ubunto
SQL
3 votes200 views5 answers
Mysql get last inserted id
SQL
1 vote258 views1 answer
Mysql current running queries
SQL