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. > > -- 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.
