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
