Hi All ,
I have a data ,
ID AMT Product
| 1 | 100 | | A |
| 1 | 100 | | B |
| 1 | 100 | | C |
| 1 | 100 | | D |
| 2 | 25 | | A |
| 2 | 40 | | E |
| 2 | 55 | | F |
| 3 | 50 | | B |
| 3 | 50 | | A |
| 3 | 50 | | C |
| 3 | 50 | | G |
| 4 | 12 | | H |
| 4 | 13 | | E |
| 4 | 14 | | A |
| 4 | 15 | | I |
i need folowing result
| ID | AMT | Product |
| 1 | 100 | A |
| 1 | 100 | B |
| 1 | 100 | C |
| 1 | 100 | D |
| 3 | 50 | B |
| 3 | 50 | A |
| 3 | 50 | C |
| 3 | 50 | G |
I have tried following query but it is not working
select
ID,
AMT,
Product
from t
group by ID,AMT,Product
having count( distinct ID)=count( distinct AMT)
It is returning all the rows.
Please help