MySQL query Select data

Question

Trying to make query for 4 hours. For example i have such data:

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

How to chose distinct title and distinct number_link ? I have marked with "<-" what i want to get from query. Thanks in advance.

can you show us what you have tried in 4 hrs?

Kalpit
– Kalpit

2013-09-26 11:35:48 +00:00
Commented Sep 26, 2013 at 11:35 — Kalpit
– Kalpit, Commented Sep 26, 2013 at 11:35

John Woo · Accepted Answer · 2013-09-26 12:08:46Z

1

This query will allows you to get all the column with in the row not just title and 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

edited Sep 26, 2013 at 12:08

answered Sep 26, 2013 at 11:38

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davey · Accepted Answer · 2013-09-26 11:36:42Z

0

SELECT title FROM table GROUP BY title, number_link

answered Sep 26, 2013 at 11:36

davey

1,7912 gold badges17 silver badges22 bronze badges

Comments

Somnath Paul · Accepted Answer · 2013-09-26 12:02:17Z

0

SELECT title,number_link FROM table GROUP BY title, number_link;

answered Sep 26, 2013 at 12:02

Somnath Paul

3101 gold badge7 silver badges17 bronze badges

Comments

toro2k · Accepted Answer · 2013-09-26 12:05:52Z

0

SELECT *
FROM table_name
GROUP BY title, number_link

edited Sep 26, 2013 at 12:05

toro2k

19.3k8 gold badges66 silver badges72 bronze badges

answered Sep 26, 2013 at 11:46

Hind Walieddine

1

Collectives™ on Stack Overflow

MySQL query Select data

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related