Is there are way to send a SQL statement to a Paradox table where I only
want to have returned the topN, where N is a user-defined parameter.
Specifically, I am trying to group on a column, sum another column, then
display the groups using the sum column as the sort order, but I want to
restrict it to only the N items.
Something like select state, sum(population) S from mytable
group by state
order by S desc
"where record count is <=5" for example