fork download
copy 
  1. create table nt (x int, y int);
  2. insert into nt values (10, 10);
  3. insert into nt values (10, 20);
  4. insert into nt values (20, 10);
  5. insert into nt values (30, 40);
  6. insert into nt values (30, 50);
  7. insert into nt values (30, 60);
  8. insert into nt values (40, 70);
  9.  
  10. select * FROM nt WHERE exists
  11. (SELECT t.* FROM nt t WHERE nt.x = t.x AND nt.y > t.y) ;
  12.  
  13. select * FROM nt WHERE exists
  14. (SELECT nt.* FROM nt t, nt nt WHERE nt.x = t.x AND nt.y > t.y) ;
  15.  
Success #stdin #stdout 0s 2964KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
10|20
30|50
30|60
10|10
10|20
20|10
30|40
30|50
30|60
40|70
https://ideone.com/3CtqN9
language:
SQLite (sqlite 3.27.2)
created:
9 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!