I have a table like the following:
Annotation ( document, term, category )
term are some ID, while
category is an integer.
term is not unique, i.e. I could have the same couple with a different category.
document_id_1, term_id_1, category_1 document_id_1, term_id_1, category_2 document_id_1, term_id_1, category_3
I would like to design a query such that it return only the couple
term for whom there exists a only a row with
category = 1.
E.g. in the previous example the couple
term_id_1 is not returned becouse there exist also other two rows, with different values of
Can you give me some hints on how to do that?