私信  •  关注

Brock Adams user254610

Brock Adams user254610 最近创建的主题
Brock Adams user254610 最近回复了
15 年前
回复了 Brock Adams user254610 创建的主题 » 如何在mysql中创建只显示最后一行的组?[重复]

试试这个:

SELECT jos_categories.title AS name,
       joined .catid,
       joined .title,
       joined .introtext
FROM   jos_categories
       INNER JOIN (SELECT *
                   FROM   (SELECT `title`,
                                  catid,
                                  `created`,
                                  introtext
                           FROM   `jos_content`
                           WHERE  `sectionid` = 6
                           ORDER  BY `id` DESC) AS yes
                   GROUP  BY `yes`.`catid` DESC
                   ORDER  BY `yes`.`created` DESC) AS joined
         ON( joined.catid = jos_categories.id )