delete records based on a minimum value per group

[mkjjj]

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

 

[ChrisHunt]

How about this?

DELETE FROM my_table
WHERE id IN (SELECT id
             FROM   my_table
             GROUP BY id
             HAVING MIN(term) < 992)

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[mkjjj]

thanks i'll try it.