OraFAQ Forum: Server Administration » select doesn't return null values

Home » RDBMS Server » Server Administration » select doesn't return null values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select doesn't return null values [message #373961]

Fri, 18 May 2001 03:52

Andrea Mainardi
Messages: 3
Registered: May 2001

Junior Member

hi everybody.
I have the following problem:

suppose to have a table containing the following values for a field 'field1':

ROW 1 --> a
ROW 2 --> b
ROW 3 --> (Null value)

if i execute this query
select field1 from table where field1 <> 'a' group by field1;

the result is

b

the rows with null values are not selected.

how can i select even the null values?
Note:
i can't modify the query using an = constraint!!
or asking for is null

Report message to a moderator

Re: select doesn't return null values [message #373967 is a reply to message #373961]

Fri, 18 May 2001 04:52

Martin
Messages: 83
Registered: February 2000

Member

select field1 from table where NVL(field1,'not a') <> 'a' group by field1;

Report message to a moderator

Previous Topic:	ora-00020 exception...urgent
Next Topic:	No

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 09:58:32 CST 2024