SELECT all the newest records distinct

Question

i have table structure like this

  sn  |  person_id  |   image_name |

   1  |   1         |      abc1.jpb 
   2  |   1         |      aa11.jpg  
   3  |   11        |      dsv.jpg
   4  |   11        |      dssd.jpg
   5  |   11        |      sdf.jpg

I need distinct person_id newest row as following

  2   |  1          |  aa11.jjpb
  5   |  11         |  sdf.jpg

IT is possible ?

Answer 1

SELECT * FROM yourtable GROUP BY person_id ORDER BY sn DESC

Essentially you want to select all records from your table. Then it is grouped by the person_id (limiting the result to 1 per person id)... Ordering by SN decending means that it will return the most recent (highest) sn

Update: (and verified)

SELECT * FROM (SELECT * FROM stackoverflow ORDER BY sn DESC) a GROUP BY person_id ORDER BY sn