php - MySQL查询选择数据

Question

尝试查询 4 ​​小时。例如我有这样的数据:

did   title      number_link    ltitle
35  about.html        1          NULL    <- this
35  about.html        2          NULL    <- this
36  about.html        1          NULL
35  contact.php       1          NULL    <- this  
35  contact.php       3          NULL    <- this  
36  contact.php       1          NULL  

如何选择不同的标题和不同的 number_link ？我用“<-”标记了我想从查询中获取的内容。提前致谢。

Answer 1

此查询将允许您获取行中的所有列，而不仅仅是 title 和 number_link。

SELECT  a.*
FROM    tableName a
        INNER JOIN
        (
            SELECT  title, number_link, MIN(did) did
            FROM    tableName
            GROUP   BY title, number_link
        ) b ON a.title = b.title AND
                a.number_link = b.number_link AND
                a.did = b.did