: Re: not all rows returned when using order by and null values?
Even more interesting...:
mysql> (SELECT avg FROM event_log_5minute_20050104 WHERE
monitor_id=479139 AND monitor_server_id=1 AND timestamp >=
2005010408 AND timestamp < 2005010508) order by avg;
+---
wrote:
> > > - Original Message -
> > > From: "John McCaskey" <[EMAIL PROTECTED]>
> > > To:
> > > Sent: Tuesday, January 04, 2005 5:22 PM
> > > Subject: not all rows returned when using order by and null values?
> > >
>
> > Sent: Tuesday, January 04, 2005 5:22 PM
> > Subject: not all rows returned when using order by and null values?
> >
> >
> > > See below:
> > > mysql> (SELECT avg FROM event_log_5minute_20050104 WHERE
> > > monitor_id=479139 AND monitor_se
On Tue, 2005-01-04 at 17:43 -0500, Rhino wrote:
> - Original Message -
> From: "John McCaskey" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, January 04, 2005 5:22 PM
> Subject: not all rows returned when using order by and null values?
>
>
>
- Original Message -
From: "John McCaskey" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 04, 2005 5:22 PM
Subject: not all rows returned when using order by and null values?
> See below:
> mysql> (SELECT avg FROM event_log_5minute_20050104 WHER
See below:
mysql> (SELECT avg FROM event_log_5minute_20050104 WHERE
monitor_id=479139 AND monitor_server_id=1 AND timestamp >=
2005010408 AND timestamp < 2005010508 order by avg);
+-+
| avg |
+-+
|NULL |
|NULL |
|NULL |
|NULL |
|NULL |
| 55854.1 |
| 5
