/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 vote318 views1 answer
How to truncate a table in databse
SQL
4 votes331 views1 answer
Sql quote in string
SQL
0 vote323 views1 answer
How to get data between a last week in mysql
SQL
11 votes354 views3 answers
How to get last row of table in sql
SQL
15 votes323 views2 answers
Sql order by multiple columns
SQL
17 votes347 views4 answers
Mysql remove ubuntu
SQL
0 vote317 views1 answer
Select top 3 sql
SQL
2 votes382 views1 answer
Pdo mysql insert
SQL
0 vote331 views1 answer
How to connect postgresql database with java
SQL
0 vote310 views1 answer
Postgres float to int
SQL