MySQL 查询选择数据

MySQL query Select data

本文关键字：数据选择查询 MySQL | 更新日期: 2023-09-27

尝试查询 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？我用"<-"标记了我想从查询中得到的东西。提前谢谢。

此查询将允许您获取行中的所有列，而不仅仅是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

SELECT title FROM table GROUP BY title, number_link

选择标题，number_link从表中按标题分组，number_link;

SELECT *
FROM table_name
GROUP BY title, number_link

MySQL 查询 选择数据

MySQL query Select data