Re: Selecte nd NULLs
- From: Phil Jones <phil@xxxxxxxxxx>
- To: "James.Clarence.Allen@xxxxxxxxxx" <James.Clarence.Allen@xxxxxxxxxx>
- Date: Thu, 26 Mar 2015 00:01:35 +0000
Ooh, @census.guv
Should we be worried about incorrect election results and population data? :)
Phil
> On 25 Mar 2015, at 14:03, James Clarence Allen (CENSUS/EPD FED)
> <James.Clarence.Allen@xxxxxxxxxx> wrote:
>
> Someone,
>
> I am doing a simple select.
>
> SQL>select distinct dbname from mytable where cluster != 'orrac1';
>
> I have a three column table "mytable" (dbname,sid,cluster). The table
> contains 206 total rows/136 rows with distinct dbname. No indices are on the
> table.
>
> Some dbnames are not in a cluster (single server) so the cluster column is
> null.
>
> When I run the select above the rows with the null in cluster column are not
> returned.
>
> Shouldn't all rows be turned except what I am filtering out?
>
> Sincerely,
> Jim Allen
> Database Support Lead, MASSDB Staff
> Schedule: Mon-Fri, 7:00am-3:30pm
> Tel: 1-301-763-7501
> Cell: 1-202-604-7286
> Database Help Desk: X34944
> Support Email: James.Clarence.Allen@xxxxxxxxxx
> Internal Website: http://epd.econ.census.gov/offices/massdb/
>
Other related posts:
