Pull the row with the smallest number in the column

Question

I have two columns called topic_id and post_id, and I want to find each row where topic_id is the lowest for each post id.

For example topic_id post_id
fifteen
2 5
3 8
4 8

This way it will capture lines 1 and 3.

I don’t even know where to start, so any help would be greatly appreciated.

Answer 1

select post_id, min(topic_id) from YourTable group by post_id 

Answer 2

I think you can do something like

 SELECT MIN(`topic_id`), `post_id` FROM `my_table` GROUP BY `post_id` 

Take a look at GROUP BY

Answer 3

 SELECT MIN(topic_id), post_id FROM T GROUP BY post_id 

Answer 4

select topic_id, min (post_id) from which group_ topic_id