Re: sql query: how to
yeah i was looking at something like that... actually let me correct
what i'm needing to do:
select year(fieldname) as pubyear from table order by year(fieldname) asc
On 09/27/2010 01:15 AM, akaariai wrote:
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 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.
Re: sql query: how to
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 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.
sql query: how to
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.
