Posted By: bam-bam (bam-bam) on 'CZdatabases'
Title:     Re: Ad: SQL - prvnich 10
Date:      Tue Oct 29 15:37:57 2002

>    Skoda, ze se to neda volat treba takto:
> SELECT ROWNUM, nazev FROM tabulka where rownum = 5
No neni nic jednodussiho nez dat vnorenej select
select rownum_a, zkratka 
from (select rownum rownum_a,zkratka from tabulka)
where rownum_a=5 

Mylit se je lidske,ale neco dokonale zasmodrchat je mozne jen pomoci pocitace.
                                                                 /Artur Bloch/

Search the boards