fork(1) download 
  1. CREATE TABLE Test (
  2. 	FK int NOT NULL,
  3. 	F1 varchar(20) NOT NULL
  4. );
  5.  
  6. INSERT INTO Test VALUES (1, 'ABC');
  7. INSERT INTO Test VALUES (1, 'DEF');
  8. INSERT INTO Test VALUES (2, 'ABC');
  9.  
  10. SELECT T1.FK
  11.      , T1.F1
  12.      , T2.F1 AS F2
  13. FROM Test T1
  14. LEFT JOIN Test T2 ON T1.FK = T2.FK AND T1.F1 <> T2.F1;
Success #stdin #stdout 0s 3008KB
comments (?)
stdin 
Standard input is empty
stdout 
1|ABC|DEF
1|DEF|ABC
2|ABC|
https://ideone.com/Bu5aae
language:
SQLite (sqlite 3.27.2)
created:
10 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!