I am having problem coming up with following query.
id| prop_id| obj_id| value|
1 7 2 1
2 8 2 1
4 7 5 7
5 8 5 12
to the query are:
- Collection of (prop_id, value) pairs
We must select records whose
match input parameters: but there is also one constrain, the
of resulting records must be same. If it is not same, result must be empty. Otherwise it must return
Let's say input parameters are: (7,1) and (8,12).
Now there are two records with such values: first and last.
of first record is 2 and
of second record is 5. Hence, the result must be empty because 2!=5.
Let's say input parameters are: (7,7) and (8,12).
Now there are two records with such values: last two records.
of first is 5 and
of second record is also 5. Hence, the result must be 5.