如何在MySQL子查询中按MAX(日期)排序?

我对此查询感到麻烦:

我有两个表:样本和歌曲
我想选择

pathName   from samples
id_user    from samples
id         from songs
name       from songs

每个样本都属于一首歌曲:我想将共享相同歌曲ID的每个样本归为一组,以便选择最后的日期.
所以我像这样在两个表之间进行联接:

$query = 'SELECT 
            samples.pathName path_name,
            samples.id_user id_user,
            songs.id id_song,
            songs.name song_name
        FROM (SELECT *, MAX(date) AS maxDate FROM samples GROUP BY id_song ORDER BY maxDate) samples
        INNER JOIN songs songs
        ON songs.id = samples.id_chanson
        WHERE songs.finished = false';

它不应该那么重,我希望我很清楚…

上一篇:mysql存储过程从select语句和参数中插入值


下一篇:mysql-使用行排序的SQL子查询的顺序反转