Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------------------------------
- | Column1 | Column2 | Column3 |
- | 1 | 2 | 3 | <-- A
- | 2 | 2 | 30 | <-- B
- | 3 | 3 | 10 |
- | 4 | 12 | 3 | <-- C
- | 1 | 3 | 3 |
- | 1 | 4 | 3 |
- | 1 | 5 | 3 |
- | 4 | 12 | 3 | <-- C
- | 2 | 2 | 30 | <-- B
- | 1 | 2 | 3 | <-- A
- | 4 | 12 | 3 | <-- C
- -------------------------------
- -------------------------------
- | Column1 | Column2 | Column3 |
- | 1 | 2 | 3 | <-- A
- | 2 | 2 | 30 | <-- B
- | 4 | 12 | 3 | <-- C
- | 4 | 12 | 3 | <-- C
- | 2 | 2 | 30 | <-- B
- | 1 | 2 | 3 | <-- A
- | 4 | 12 | 3 | <-- C
- -------------------------------
- SELECT Column1,Column2,Column3 FROM Table GROUP BY Column1,Column2,Column3 HAVING COUNT(*)>1
- SELECT x.* FROM Table x INNER JOIN (
- SELECT Column1,Column2,Column3 FROM Table GROUP BY Column1,Column2,Column3 HAVING COUNT(*)>1
- ) y ON x.Column1=y.Column1 AND x.Column2=y.Column2 AND x.Column3=y.Column3
- SELECT Column1, Column2, Column3, count(*) from myTable
- GROUP BY Column1, Column2, Column3
Add Comment
Please, Sign In to add comment