Select last distinct row

[michaeljohn]

I've got a table with some duplicate entries, I've been trying different query combinations but I've been unable to solve this problem.

 

Here is an example of my problem

 

 

 

Basically I would like to get the last distinct value (entry id: 9634), I've got many item_id's with duplicate field_value's, what would be the best query to display this?

 

 

Here is my query

SELECT DISTINCT `field_id` , `field_value` , `item_id` , `entry_id`

FROM `ibf_registry_field_entries`

ORDER BY `entry_id` DESC

 

[Zane]

I'm no SQL expert but maybe

SELECT DISTINCT `field_id` , `field_value` , `item_id` , `entry_id`
FROM `ibf_registry_field_entries`
ORDER BY `entry_id` ASC
LIMIT 1

 

[fenway]

What you need to do is get the max entry_id for each "set", then join this back to the original table.