Posted by BarrySDCA on 03/03/06 00:00

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: Re: How does one set read-uncommitted on the entire DB?
• Thread view: How can I remove duplicate entries in a sql query?

[Reply to this message]