fork download
copy 
  1. CREATE TABLE t (cust_id, item);
  2.  
  3. INSERT INTO t VALUES (1,'book');
  4. INSERT INTO t VALUES (1,'shoe');
  5. INSERT INTO t VALUES (2,'book');
  6. INSERT INTO t VALUES (3,'shoe');
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
SELECT cust_id FROM t WHERE item='book'
INTERSECT 
SELECT cust_id FROM t WHERE item='shoe';
stdout
copy 
1
https://ideone.com/V74E4
language:
SQLite (sqlite 3.27.2)
created:
11 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!