here's the case

i've got a table which got 3 field
1. id(varchar)
2. state1(int)
3. state2(int)
i've set all of them as primary key, which mean combination of the three field should be unique

the problem

value of state2 ranged from 0 to 99, is there a way for me to filter row when the value of state2 is 0 and when there's another row with same id and state1 with state2 more than 0?.

Note that there may be more than one value which is more than 0 and i hope them to stay that way.

is it possible to achieve this in pentaho?

Thanks in advance