duplicate records, show only the last one (1 Viewer)

R

Robo0502

Registered User.

Local time

Today, 04:38

Joined

May 22, 2015

Messages

23

• Jun 24, 2015

• #1

Hi guys.

I have a table and there are so called duplicate records (not entirely duplicate because there is field with the date of creation and other differences in a few fields, but from my point of view they are duplicates.). I d like to make a query which shows me only the newest record in case of duplicity.

can u pls help me with that?

thanks

 

pr2-eugin

Super Moderator

Local time

Today, 03:38

Joined

Nov 30, 2011

Messages

8,494

• Jun 24, 2015

• #2

Try a GROUP BY Query, with a Max on the Date Field.

 

P

plog

Banishment Pending

Local time

Yesterday, 21:38

Joined

May 11, 2011

Messages

11,638

• Jun 24, 2015

• #3

and other differences in a few fields

Click to expand...

If that's true MAX on the date alone won't do it, and you are going to tell me what constitutes a "duplicate". Then you will need a sub-query. Can you provide some sample data? Include 2 sets:

A. Starting data from your table. Include enough records to cover all cases and include table and field names.

B. Expected results based on A. Using the data you supply in A, show what you want the query to return.

 

R

Robo0502

Registered User.

Local time

Today, 04:38

Joined

May 22, 2015

Messages

23

• Jun 25, 2015

• #4

Thank you guys. You were right. I solved it using Group by query and sub-query.