-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 17:57 Hathaway, Scott L wrote:
> Yes, that should only cause a reordering within the group itself, but in my
> case, the group breaks into two groups!
Your 'group by' clause needs to have the same fields (and in the same
with query, pelase
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 15:29 Hathaway, Scott L wrote:
> I have the following query:
>
> select *, max(event_date) as high, min(event_date) as low from schedule
> where event_date between '2002-03-01' and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 15:29 Hathaway, Scott L wrote:
> I have the following query:
>
> select *, max(event_date) as high, min(event_date) as low from schedule
> where event_date between '2002-03-01' and '2003-04-30' group by
> week_ending,meeti
I have the following query:
select *, max(event_date) as high, min(event_date) as low from schedule
where event_date between '2002-03-01' and '2003-04-30' group by
week_ending,meeting_id order by name, event_date, start_time
If I order by event_date, start_time, name, I get the proper results.