Are you thinking of limit?
On 7/2/2010 9:58 AM, Simon Slavin wrote: > On 2 Jul 2010, at 5:15pm, Peng Yu wrote: > > >> I want to select an entry that appears >> <=n times and only show n times if it appears more than n times. I >> think that "group by" might help. >> > There's no simple format which will do what you want. Do it in software. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users