Re: query on query

On Fri, Jul 5, 2013 at 5:09 AM, Jayadevan M
<jayadevan.maymala@ibsplc.com> wrote:

>
> So each student may get counted many times, someone with 99 will be counted
> 10 times. Possible to do this with a fat query? The table will have many
> thousands of records.
>


Not sure I got the point, but I guess this is a good candidate for a CTE:

WITH RECURSIVE t(n) AS (
    VALUES (10)
  UNION ALL
    SELECT n+10 FROM t WHERE n < 50
)
select count(*), t.n from m, t where mark > t.n group by t.n;

Luca