View PlGroup Datenmengen
| ID | 39 |
|---|---|
| Text | Datenmengen |
| Title | Not set |
PlItems
- SELECT field_to_compare FROM Destination_Table EXCEPT SELECT field_to_compare FROM Source_Table
- SELECT TOP 100 * FROM tableA
- SELECT * FROM tableA LIMIT 100;
- SELECT * FROM ( SELECT * FROM tableA ) WHERE ROWNUM <= 100
- 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
- WITH a AS ( SELECT 1 AS n UNION ALL SELECT 2 AS n UNION ALL SELECT 3 AS n UNION ALL SELECT 4 AS n ), b AS ( SELECT 4 AS n UNION ALL SELECT 5 AS n UNION ALL SELECT 6 AS n UNION ALL SELECT 7 AS n ) SELECT * FROM a EXCEPT -- <------------------------------ SELECT * FROM b