Mysql - group showing all the data the last row by group

Question

The question is the following: How can I group in the table, but showing all the data the last row the group

Query Table

score  team    stadium            date
20     Ajax    Arena Stadium      '26/Feb/2020'
10     Madrid  Santiago Bernabeu  '26/Feb/2020'
10     Ajax    Arena Stadium      '22/Feb/2020'

Expected result

score  team    stadium            date
20     Ajax    Arena Stadium      '26/Feb/2020'
10     Madrid  Santiago Bernabeu  '26/Feb/2020'

Regards

How about `SELECT TOP 2 ...` https://stackoverflow.com/questions/1891789/sql-select-first-10-rows-only/36476971? — TDuong, Feb 26 '20 at 18:13

score 1 · Answer 1 · answered Feb 26 '20 at 18:17

1

Try this

SELECT score, team, stadium, date
FROM (
    SELECT 
        , ROW_NUMBER() OVER(PARTITION BY score, team ORDER BY date DESC) AS rn
    FROM yourTable
) tbl
WHERE rn = 1

answered Feb 26 '20 at 18:17

Eric

3,165
1
19
25

select team from myTable group by team this is my attempt, but if your group it without considering score? – lyonTypescript Feb 26 '20 at 18:33

Mysql - group showing all the data the last row by group

1 Answers1