Posted by figital on 10/01/28 11:41

I'm not sure why you need a nested query as others have suggested.

I see two options:

Select Distinct blah1, blah2, [all fields except event_id], blah99
>From LoginTable

or

Select blah1, blah2, [all fields except event_id], blah99
>From LoginTable
Group by blah1, blah2, [all fields except event_id], blah99

if you want an event_id, just for kicks, you could add an aggregator:

Select blah1, blah2, max(event_id), blah99
>From LoginTable
Group by blah1, blah2, [all fields except event_id], blah99

• Next in forum: Query Memory?
• Prev in forum: Re: Referential Integrity - linking multiple tables to transaction table
• Thread view: Re: How can I remove duplicate entries in a sql query?

[Reply to this message]