fork download
copy 
  1. CREATE TABLE numeros (
  2.   num INT
  3. );
  4.  
  5. INSERT INTO numeros (num) VALUES (1);
  6. INSERT INTO numeros (num) VALUES (2);
  7. INSERT INTO numeros (num) VALUES (3);
  8. INSERT INTO numeros (num) VALUES (4);
  9.  
  10. CREATE TABLE pares (
  11.   num INT
  12. );
  13.  
  14. INSERT INTO pares (num) VALUES (2);
  15. INSERT INTO pares (num) VALUES (4);
  16. INSERT INTO pares (num) VALUES (6);
  17. INSERT INTO pares (num) VALUES (8);
  18.  
  19. SELECT * FROM numeros WHERE num IN (SELECT num FROM pares);
Success #stdin #stdout 0s 4696KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
2
4
https://ideone.com/he4Ee7
language:
SQLite (sqlite 3.27.2)
created:
3 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!