How to show last data with created date?

Asked May 24 '19 at 01:40

Active May 24 '19 at 01:43

Viewed 19 times

I have a problem to show one of duplicate data with last created date. This is is my query :

 $sqlpur ="SELECT DISTINCT pn, created_date, id_purchase FROM pur_supp ORDER BY pn, created_date DESC";

This is the result.

This is a data from database.

But, I want to show just one of duplicate data. an example just to show 02N64073 with last created Date.

asked May 24 '19 at 01:40

have you tried `group`ing them using the column that you provided above? – Kevin May 24 '19 at 01:45
@Ghost, at the first time I using Distinct of this duplicate date but when I'm confused to show pn with last created date – Franksye Sipangkar May 24 '19 at 01:55

0 Answers0