Selecte nd NULLs
- From: "James Clarence Allen (CENSUS/EPD FED)" <James.Clarence.Allen@xxxxxxxxxx>
- To: Oracle Chat freelist <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Mar 2015 14:03:58 +0000
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<mailto:James.Clarence.Allen@xxxxxxxxxx>
Internal Website: http://epd.econ.census.gov/offices/massdb/
Other related posts:
