Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

On Fri, Jul 2, 2010 at 11:35 AM, Black, Michael (IS) wrote: > I don't know about anybody else but I can't tell what you want to do. > > Have you got some sample data and the results you expect from it? > > > Michael D. Black > Senior Scientist > Northrop Grumman Mission Systems > > > _

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

Maybe this? SELECT, min(Count(type_id),n) FROM foods GROUP BY ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EXTERNAL:Re: How to select an entry that appears <=n times and only show n times if it appears more than n times?

I don't know about anybody else but I can't tell what you want to do. Have you got some sample data and the results you expect from it? Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqlite.org on behalf of Pe