Message -
From: Bhavin Vyas [EMAIL PROTECTED]
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 Ranges
... :-(
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 - query suggestion needed -
interesting case
How about:
SELECT
event_id, time,
count(DISTINCT
]
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 Ranges
FROM
events
GROUP BY
event_id HAVING Ranges 1
.
Thanks anyway. I may have to use second 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 - query suggestion needed - interesting case
How about
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
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
I need to know all event_id's that have multiple times + time columns