rows
id term
1 932
1 934
2 992
2 1008
3 944
3 1014
I want to delete any ids if their first term was less than 992 so in the example above, only the 2 rows for id 2 would remain in the database, since id 2 first term is 992. I'm thinking that I would need a group by and having but not sure where in a statement to place it.
Help is appreciated. Thank you
id term
1 932
1 934
2 992
2 1008
3 944
3 1014
I want to delete any ids if their first term was less than 992 so in the example above, only the 2 rows for id 2 would remain in the database, since id 2 first term is 992. I'm thinking that I would need a group by and having but not sure where in a statement to place it.
Help is appreciated. Thank you