blob: f6ebbc1d5926d02b1716fddd1fa5fdd0ac9c586b (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
# Classic SQL constructs not supported yet
## \[NOT\] \[EXISTS|INTERSECT\|EXCEPT] {#not-exists}
A syntactically available alternative is `EXISTS`, but it's not very useful as it doesn't support correlated subqueries. You can also rewrite it using `JOIN`.
## NATURAL JOIN {#natural-join}
An alternative is to explicitly list the matching columns on both sides.
## NOW() / CURRENT_TIME() {#now}
An alternative is to use the functions [CurrentUtcDate, CurrentUtcDatetime and CurrentUtcTimestamp](../builtins/basic.md#current-utc).
|
