Existuje obdoba LIMIT pro ORACLE ?

Vladimir Naprstek vladimir.naprstek na prodeco.cz
Úterý Březen 6 12:03:56 CET 2001


Michal Zaschke wrote:
> 
> Jen je (do verze tusim 8.0.5) problem, pokud chcete mit vysledky
> serazene a chcete jen vysek, treba 10 radku od pateho.
> Napr.: select * from tabulka order by sloupec limit 5,10
>   neni v MySQL problem, v Oracle vsak ano
> 
> M.Z.
> 
To uz musite nejak obejit v aplikaci, napriklad pouzijete 
SELECT * FROM tabulka WHERE rownum < 10
a potom prvnich 5 radku ve smycce preskocite.
Take muzete zkusit neco takoveho:
SELECT * FROM tabulka WHERE rownum < 10 MINUS SELECT * FROM tabulka
WHERE rownum < 5;

Zalezi jen na Vas...

Obavam se, ze limit z mysql neni obsazen v definici sql. Stejne muzeme
plakat, ze mysql nema xxxxx a Oracle ano...

> >
> > SELECT * FROM tabulka WHERE rownum < 35;
> >
> > ROWNUM
> > For each row returned by a query, the ROWNUM pseudocolumn returns a
> > number indicating the order in which Oracle selects the row from a table
> > or set of joined rows. The first row selected has a ROWNUM of 1, the
> > second has 2, and so on. You can use ROWNUM to limit the number of rows
> > returned by a query, as in this example:
> >  SELECT * FROM emp WHERE ROWNUM < 10;
> >
> > dalsi viz dokumentace Oracle...

-- 
Vladimír Náprstek	e-mail: vladimir.naprstek na prodeco.cz


Další informace o konferenci Databases