>>return just the first time row per each event_id.
>>
>>Thanks anyway. I may have to use second query... :-(
>>
>>
>>Mihail
>>
>>
>>- Original Message -
>>From: "Bhavin Vyas" <[EMAIL PROTECTED]>
>>To: &q
cond query... :-(
>
>
> Mihail
>
>
> - Original Message -
> From: "Bhavin Vyas" <[EMAIL PROTECTED]>
> To: "Mihail Manolov" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Thursday, July 11, 2002 10:51 PM
> Subject: Re: Help - qu
GROUP BY
>> event_id HAVING Ranges > 1
>>
>>
>>- Original Message -
>>From: "Mihail Manolov" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Thursday, July 11, 2002 2:58 PM
>>Subject: Help - query suggestion ne
ROTECTED]>
To: "Mihail Manolov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 10:51 PM
Subject: Re: Help - query suggestion needed - interesting case
> How about:
>
> SELECT
> event_id, time,
> count(DISTINCT time) AS Ran
PM
Subject: Help - query suggestion needed - interesting case
> Greetings,
>
> I am stuck with this problem:
>
> I have the following table:
>
> event_id time
> 1002000-10-23
> 1002000-10-23
> 1012000-10-24
> 1012000-10-25
>
&g
Greetings,
I am stuck with this problem:
I have the following table:
event_id time
1002000-10-23
1002000-10-23
1012000-10-24
1012000-10-25
I need to know all event_id's that have multiple times + time columns. Is it
possible to get that result in just one quer
