mysql - 如何从mysql中的重复行中获取单行

Question

我只想从返回的重复的aspect_id(rows)数量中获取1行。

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'; 

有什么方法可以根据aspect_id获取不同的行吗？

Answer 1

使用分组依据:

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;