Jak vybrat 100000. radek

[Honza Pazdziora]

On Sat, May 20, 2000 at 10:14:36AM +0200, Vojtech Novacek wrote:
> 
> To mate pravdu, ale nic vam nebrani pridat ORDER BY do toho zakladniho
> selectu.

Neco mi brani:

	select * from ( select * from tabulka order by id );
	ORA-00907: missing right parenthesis

8.0.4.

> Napr.  select * from tabulka order by neco, kde se radky setridi a rownum
> se vygeneruje az tim druhym selectem.
> Pokud stale neverite, mam to vyzkousene.

Verim, ze treba 8.1.* to uz umi.

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