Re: Display only part of resultset

> ------------------------------------------
> SELECT nazev, psh1
> FROM (SELECT nazev, psh1 FROM vw_stk WHERE id_psh1=10 ORDER BY nazev)
> WHERE ROWNUM<=20;
> ------------------------------------------
> The problem is, that I can't take other records (only first ones) using
this
> technique (condition WHERE ROWNUM>20 AND ROWNUM<=40 can't work, because
> ROWNUM is just pseudocolumn created dynamically).

You can use rownum:

 SELECT nazev, psh1

     FROM (
         SELECT rownum rn, nazev, psh1
           FROM vw_stk
           WHERE id_psh1=10
       ORDER BY nazev) a
     WHERE A.RN <= 20;

--
Noel