please give me the result of this select statement


[ ruban.de ] [ Antworten ] [ Forum ]

Geschrieben von raghavendher thimmana on Oktober 23, 2003 um 08:12:

Als Antwort auf Monitoring geschrieben von Michael Herzog on Oktober 20, 2003 um 13:40:

hello..

consider the following query...

select * from table_name where (condition)

the condition is a comparision which has a null value as one of the values being compared.. so the condition would be unknown..

what would be the result of the select statement with an "unknown" as the where part..

would it be an empty relation or the whole relation...

please mail me if anyone could...

raghavendher thimmana.


Antworten:


Schreibe eine Antwort

Name:   
E-Mail:  

Thema:

Kommentar:

Optionale Link URL:   
Link Titel:                  
Optionale Image URL:


[ Antworten ] [ Forum ]