Usually, when you are asking these kind of questions, you come to realize you are asking the wrong question.
On Monday, July 23, 2012 3:15:14 PM UTC-7, Mark Li wrote: > > I have a database setup with id and 'dogname.' I would like to retrieve > distinct values of dogname, but allow for 2 of each dogname. So instead of > limiting it to one distinct value, there could be 2 identical dognames that > are retrieved, but no more than that. > > Is there a way to set this kind of limit for distinct? > --