Sha256: 288a2ed8f960f73765d76b1f530459ded9f649fc11849c517573a60ecf968ad5
Contents?: true
Size: 692 Bytes
Versions: 5
Compression:
Stored size: 692 Bytes
Contents
- alf: |-
minus(suppliers_in_london, suppliers_in_paris)
sql:
(SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
WHERE t1.city = 'London')
EXCEPT
(SELECT t2.sid, t2.name, t2.status, t2.city
FROM suppliers AS t2
WHERE t2.city = 'Paris')
- alf: |-
minus(minus(suppliers_in_london, suppliers_in_paris), suppliers)
sql:
((SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
WHERE t1.city = 'London')
EXCEPT
(SELECT t2.sid, t2.name, t2.status, t2.city
FROM suppliers AS t2
WHERE t2.city = 'Paris'))
EXCEPT
(SELECT t3.sid, t3.name, t3.status, t3.city
FROM suppliers AS t3)
Version data entries
5 entries across 5 versions & 1 rubygems