Jak vybrat 100000. radek

[Honza Pazdziora]

On Thu, May 18, 2000 at 09:07:29AM +0200, Vojtech Novacek wrote:
> 
> select neco from
> 	(select neco, rownum as pos from tabulka)
> where pos = 100000
> 
> pripadne:
> 
> select * from
> 	(select x.*, rownum as pos from
> 		(select * from tabulka)
> 	) x
> where pos = 100000
> 
> Tento postup se da mimochodem pouzit i jako nahrada postgreSQL( a
> myslim i MySQL) syntaxe limit ... offset, pokud v podmince bude napr.:

Jediny a zakladni problem je v tom, ze typicky chcete vybrat
100000-ity zaznam ze setrideneho seznamu podle nejakeho kriteria.
To pomoci limit v MySQL udelate (limit se provadi az za order by),
ale v Oraclu touto konstrukci nikoli.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, MTB, Spain.
------------------------------------------------------------------------