Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cd c1 c2 d1
- ----------------
- aa 23 681 4850
- aa 23 942 4850
- aa 28 944 4881
- aa 28 221 4850
- bb 46 443 9082
- cc 77 171 2831
- cc 77 272 2831
- dd 18 798 5993
- xx 71 166 8755
- xx 71 482 3818
- xx 71 565 7598
- xx 71 603 7246
- xx 71 649 4293
- xx 71 681 7321
- xx 71 250 7453
- xx 22 276 3818
- xx 22 107 8755
- yy 28 143 5802
- zz 33 624 3205
- zz 33 767 1532
- zz 33 372 3205
- zz 33 679 3838
- SELECT cd, c1, c2, d1
- FROM test_data
- WHERE cd IN (SELECT cd FROM test_data group by cd having count(cd) > 3)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement