Re: Limit lines from a query

Hi,

> Hi use
>
> rownum<11

I get a error message, if ein use HAVING rownum < 11in the SQL statement

it is possible to limit the lines from a query like

select a, sum(b) from tab
group by a
order by sum(b) desc

having rownum < 11
down work

any ideas? Received on Sat Mar 11 2000 - 00:00:00 CST