Umm... Don't know, actually. That seems, that it would be okay, too. Is there a way to execute this one using ORM?
On Wed, Jan 19, 2011 at 2:04 PM, Cal Leeming [Simplicity Media Ltd] < cal.leem...@simplicitymedialtd.co.uk> wrote: > May I ask why you didn't just use: > > SELECT id from table GROUP BY tablefield HAVING (COUNT(tablefield) > 1) > > On Wed, Jan 19, 2011 at 11:02 AM, [CPR]-AL.exe <cpr.al....@gmail.com>wrote: > >> Hi there. >> >> I'm trying to do something like this: >> >> SELECT * >> FROM table >> WHERE tablefield IN ( >> SELECT tablefield >> FROM table >> GROUP BY tablefield >> HAVING (COUNT(tablefield ) > 1) >> ) >> >> Tried it in many ways, but didn't suceed. Is there a way to do it with >> Django ORM without having to iterate over objects or using raw SQL? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To post to this group, send email to django-users@googlegroups.com. >> To unsubscribe from this group, send email to >> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/django-users?hl=en. >> >> > -- Sincerely yours, Alexey. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@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.
