3 ms·
The book says this is a valid where clause: > WHERE 0 > 1 and 0 are the most basic Boolean statements. This block guarantees that no rows will be returned. T
by default-kramer 8y ago
The book says this is a valid where clause:
> WHERE 0
> 1 and 0 are the most basic Boolean statements. This block guarantees that no rows will be returned.
This doesn't work in SQL Server and it has always bothered me. But is it part of any SQL standard?
The book also says this is an invalid where clause:
> WHERE '%obert%' LIKE first_name
> More than one wildcard is fine. But the pattern has to come after the LIKE operator.
This one is probably a bug/mistake, but it's definitely not invalid in the SQL language.