I'm not quite sure what you meant by "only show n times if it appears more
than n times'. Is the pseudo-code below analogous to what you are trying
to do?
for each surname in
(select surname from phone-book order by surname)
{
print surname no more than n times
}
Regards
Tim Romano
Swarthmore PA
> > 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.
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
