Hello ALL,
I have a table contains words extracted from a few documents.
DocID Word Tag
1 Book noun
1 Pen noun
1 Pencil noun
2 There prep
2 Hand noun
2 Have verb
3 Oil noun
3 Thorough adv
3 Drive verb
4 Red adj
4 Blue adj
4 Pike adj
I would like to select those (noun or verb) records in the documents which contains more than or equal to two nouns or verbs. Actually I want the following result
DocID Word Tag
1 Book noun
1 Pen noun
1 Pencil noun
2 Hand noun
2 Have verb
3 Oil noun
3 Drive verb
How to do this with a SQL query. Thanks