The most efficient? Exactly that using raw SQL. I think something
along the following will also work:
Foo.objects.only('fieldname').value_list().distinct().order_by('fieldname').- Anssi On Sep 27, 5:49 am, Bobby Roberts <tchend...@gmail.com> wrote: > what is the most efficient way to do the following sql command in > django? > > select distinct fieldname from table order by fieldname -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
