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

enter image description here

From the above data result should display

enter image description here

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

goromlagche · Accepted Answer · 2013-08-26 16:32:51Z

5

StudentAppeared.objects.distinct()

sorry made a mistake. fixed it

edited Aug 26, 2013 at 16:32

answered Aug 25, 2013 at 8:45

goromlagche

4421 gold badge5 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Endre Both Over a year ago

This returns all five rows as the ids are distinct.

Lewis Menelaws Over a year ago

Also take into consideration too that this doesn't work on SQLite backends (if you are in development)

Endre Both · Accepted Answer · 2019-03-12 16:05:31Z

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')
)

answered Mar 12, 2019 at 16:05

Endre Both

5,8201 gold badge30 silver badges32 bronze badges

Collectives™ on Stack Overflow

Exclude Duplicate Objects in django queryset

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related