Posted by das on 03/03/06 00:25

try this, not tested :-)

SELECT *
FROM table1 a,
(SELECT min(id) FROM table1) AS b
WHERE a.id = b.id


BarrySDCA wrote:
> I have a database being populated by hits to a program on a server.
> The problem is each client connection may require a few hits in a 1-2
> second time frame. This is resulting in multiple database entries -
> all exactly the same, except the event_id field, which is
> auto-numbered.
>
> I need a way to query the record w/out duplicates. That is, any
> records exactly the same except event_id should only return one record.
>
> Is this possible??
>
> Thank you,
>
> Barry

• Next in forum: Re: How can I remove duplicate entries in a sql query?
• Prev in forum: 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]