Posted by Thomas Kellerer on 03/03/06 01:54

Haven't tested this:

SELECT *
FROM playback_log a
WHERE a.event_id = (select min(event_id) from playback_log b
where a.field1 = b.field1)
;

You will need to list as many fields as need to match the identical rows in the
where clause of the sub-select.

Thomas


BarrySDCA wrote on 03.03.2006 00:33:
> hrm....no luck. I ran this:
>
>
> SELECT * from `playback_log` a,(SELECT min(EVENT_ID) FROM
> `playback_log` ) AS b WHERE a.EVENT_ID = b.EVENT_ID
>
>
> Can you see anything? I appreciate the help a bunch. thank you
>

• Next in forum: Re: How can I remove duplicate entries in a sql query?
• Prev in forum: Re: How can I remove duplicate entries in a sql query?
• Thread view: Re: How can I remove duplicate entries in a sql query?

[Reply to this message]