Thanks, I was being dumb and have figured it out now by doing a MIN() on the Value column and using GROUP BY on the UserId and Answer column. I didn't mind which gets returned to be honest, I just completely forgot how to do it 🙂