f*g
2 楼
A value of NULL indicates the value is unknown. A value of NULL is different
from an empty or zero value. No two null values are equal. Comparisons between
two null values, or between a NULL and any other value, return unknown because
the value of each NULL is unknown.
Null values usually indicate data that is unknown, not applicable, or to be
added at a later time. For example, a customer's middle initial may not be
known at the time the customer places an order.
【在 s**********r 的大作中提到】
: why? thanks
s*i
3 楼
NULL is NULL. null is not unkown. if you know a value
is null, it's not any other value, it's just null.
basically null means no set value.
【在 f***g 的大作中提到】
:
: A value of NULL indicates the value is unknown. A value of NULL is different
: from an empty or zero value. No two null values are equal. Comparisons between
: two null values, or between a NULL and any other value, return unknown because
: the value of each NULL is unknown.
: Null values usually indicate data that is unknown, not applicable, or to be
: added at a later time. For example, a customer's middle initial may not be
: known at the time the customer places an order.
h*n
6 楼
well, maybe this is useful for dating service, bf/gf search engine. :P
select a.ID, a.FirstName, a.LastName, b.ID, b.FirstName, b.LastName
from Male a, Female b
where ( a.GirlFriendID IS NULL and a.IsGay = FALSE and
b.BoyFriendID IS NULL and b.IsLesbian = FALSE)
【在 l********h 的大作中提到】
: What did you try to do?
: Why did you want to compare NULL to NULL?
: Could you provide your SQL statement?
select a.ID, a.FirstName, a.LastName, b.ID, b.FirstName, b.LastName
from Male a, Female b
where ( a.GirlFriendID IS NULL and a.IsGay = FALSE and
b.BoyFriendID IS NULL and b.IsLesbian = FALSE)
【在 l********h 的大作中提到】
: What did you try to do?
: Why did you want to compare NULL to NULL?
: Could you provide your SQL statement?
相关阅读
问个初级问题考MCDBA还是ORACLE的证书?如何migrate Oracle DB问一道几何题JVM verison of Oracle 9.2请问哪里有sql语句追踪工具SQL 问题 [zz]请教一个关于JDBC的问题,实在太烦了!SQL Server查询页面处理问题Has anybody used Sybase? Urgent help!This board is dead now推荐本好的DATABASE 教材请推荐sybase的书PostgreSQL Unicode问题Sybase Server setting questionswhat is AARCZ使用MS Access问题Perl安装DBD::oracle的问题(linux,server不在本机)query操作[转载] 想自学MS. Access and Excel,网上哪儿有比较好的