Exclude Duplicate Objects in django queryset

Question

I have model called StudentAppeared

class StudentAppeared(models.Model):
    roll_number = models.CharField(max_length=50)

Assume i have following data

From the above data result should display

How can i achieve this thing using django query for StudentAppeared model?

Answer 1

StudentAppeared.objects.distinct()

sorry made a mistake. fixed it

Answer 2

This returns unique roll_numbers with the highest associated id, sorted by id:

from django.db.models import Max

stats = (
    StudentAppeared.objects
    .values('roll_number')
    .annotate(max_id=Max('id'))
    .values_list('max_id', 'roll_number ')
    .order_by('max_id')
)