/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 vote97 views1 answer
Round function in sql oracle
SQL
4 votes102 views1 answer
Sql query to make a existing column auto increment
SQL
4 votes100 views2 answers
How to count items with same name in sql
SQL
0 vote103 views1 answer
How to check default value of column in sql server
SQL
11 votes110 views2 answers
Safe mode off mysql
SQL
2 votes119 views1 answer
Sql server current date minus 5 years
SQL
1 vote108 views1 answer
Sql select row with max date
SQL
1 vote99 views1 answer
Sql group by error
SQL
-1 vote58 views2 answers
Sql query examples
SQL
0 vote98 views1 answer
Automatically update database last seen datetime in sql
SQL