fork download
copy 
  1. create table xyz (a integer, b varchar(5));
  2. insert into xyz values (1, 'te');
  3. insert into xyz values (1, 'we');
  4. insert into xyz values (1, 're');
  5. insert into xyz values (2, 'te');
  6. insert into xyz values (2, 're');
  7. insert into xyz values (3, 'ge');
  8. insert into xyz values (4, 're');
  9. select a from xyz where a not in (select a from xyz where b='te');
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
3
4
https://ideone.com/ekSf8I
language:
SQLite (sqlite 3.27.2)
created:
12 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!