How to get a single row from the duplicate rows in mysql

Question

I want to get only 1 row from the number of duplicate aspect_id(rows) returned.

SELECT rt.taxonomy_id,rt.iteration,ra.* FROM request_taxonomy rt 
inner join request_aspects ra ON ra.aspect_id = rt.request_aspects_id
                WHERE rt.requests_id = 6 and ra.section_name='Timeline';

Is there any way to get the distinct rows based on aspect_id?

GROUP BY can help you

Sumit Pandey
– Sumit Pandey

2015-10-28 07:50:11 +00:00
Commented Oct 28, 2015 at 7:50 — Sumit Pandey
– Sumit Pandey, Commented Oct 28, 2015 at 7:50

phsaires · Accepted Answer · 2015-10-28 07:52:19Z

1

Use GROUP BY:

SELECT 
    rt.taxonomy_id,rt.iteration,ra.* 
FROM request_taxonomy rt 
        inner join request_aspects ra ON ra.aspect_id = rt.request_aspects_id
WHERE rt.requests_id = 6 and ra.section_name='Timeline'
GROUP BY aspect_id;

answered Oct 28, 2015 at 7:52

phsaires

2,4281 gold badge16 silver badges11 bronze badges

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

Comments

Sumit Pandey · Accepted Answer · 2015-10-28 07:51:18Z

1

GROUP BY can help you

SELECT rt.taxonomy_id,rt.iteration,ra.* 
FROM request_taxonomy rt 
inner join request_aspects ra ON ra.aspect_id = rt.request_aspects_id
WHERE rt.requests_id = 6 and ra.section_name='Timeline' 
GROUP BY aspect_id;

answered Oct 28, 2015 at 7:51

Sumit Pandey

4482 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to get a single row from the duplicate rows in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related