Differenzen anzeigen
| ID | 294 | ||||
|---|---|---|---|---|---|
| Link Reference | https://gist.github.com/yancya/bf38d1b60edf972140492e3efd0955d0 | ||||
| Link Credits | Not set | ||||
| Link Technical Documentation | Not set | ||||
| PlCodelang | BigQuery | ||||
| PlGroup | Datenmengen | ||||
| PlItemTitle | Differenzen anzeigen | ||||
| Code | WITH a AS ( SELECT * FROM UNNEST([1,2,3,4]) AS n ), b AS ( SELECT * FROM UNNEST([4,5,6,7]) AS n ) SELECT * FROM a EXCEPT DISTINCT -- <------------------ SELECT * FROM b | ||||
| Result Example |
|