Guest User

Untitled

a guest
Jul 20th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. -------------------------------
  2. | Column1 | Column2 | Column3 |
  3. | 1 | 2 | 3 | <-- A
  4. | 2 | 2 | 30 | <-- B
  5. | 3 | 3 | 10 |
  6. | 4 | 12 | 3 | <-- C
  7. | 1 | 3 | 3 |
  8. | 1 | 4 | 3 |
  9. | 1 | 5 | 3 |
  10. | 4 | 12 | 3 | <-- C
  11. | 2 | 2 | 30 | <-- B
  12. | 1 | 2 | 3 | <-- A
  13. | 4 | 12 | 3 | <-- C
  14. -------------------------------
  15.  
  16. -------------------------------
  17. | Column1 | Column2 | Column3 |
  18. | 1 | 2 | 3 | <-- A
  19. | 2 | 2 | 30 | <-- B
  20. | 4 | 12 | 3 | <-- C
  21. | 4 | 12 | 3 | <-- C
  22. | 2 | 2 | 30 | <-- B
  23. | 1 | 2 | 3 | <-- A
  24. | 4 | 12 | 3 | <-- C
  25. -------------------------------
  26.  
  27. SELECT Column1,Column2,Column3 FROM Table GROUP BY Column1,Column2,Column3 HAVING COUNT(*)>1
  28.  
  29. SELECT x.* FROM Table x INNER JOIN (
  30. SELECT Column1,Column2,Column3 FROM Table GROUP BY Column1,Column2,Column3 HAVING COUNT(*)>1
  31. ) y ON x.Column1=y.Column1 AND x.Column2=y.Column2 AND x.Column3=y.Column3
  32.  
  33. SELECT Column1, Column2, Column3, count(*) from myTable
  34. GROUP BY Column1, Column2, Column3
Add Comment
Please, Sign In to add comment