fork(2) download 
  1. -- your code goes here
  2. CREATE TABLE Accounts
  3. 	(`user` int, `account` varchar(7))
  4. ;
  5.  
  6. INSERT INTO Accounts
  7. 	(`user`, `account`)
  8. VALUES
  9. 	(1, 'A'),
  10. 	(1, 'A'),
  11. 	(1, 'A'),
  12. 	(2, 'B'),
  13. 	(2, 'C'),
  14. 	(2, 'C')
  15. ;
  16.  
  17. SELECT DISTINCT *
  18. FROM Accounts INNER JOIN (
  19.   SELECT user
  20.   FROM (
  21.     SELECT *
  22.     FROM Accounts
  23.     GROUP BY user, account
  24.   ) temp1
  25.   GROUP BY user
  26.   HAVING COUNT(*) > 1
  27. ) temp2 ON temp2.user = Accounts.user;
Success #stdin #stdout 0s 3444KB
comments (?)
stdin 
Standard input is empty
stdout 
2|B|2
2|C|2
https://ideone.com/zSd2tp
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!