Re: SQL Problem

From: W v A <wesselX_at_Xwau.mis.ah.nl>
Date: Wed, 8 Jul 1998 10:49:12 GMT
Message-ID: <EvrvDo.8D6@ahisinfr.xs4all.nl>

In article <359CC1AA.5295E0AE_at_ipmultimedia.es>, Elena Sotelo <esotelo_at_ipmultimedia.es> wrote:
>Hi, all!
>
> I have a problem with SQL SELECT. I want to do a SELECT of a
>determinate row, by example, "select ...row(500)... from table".
>
> Can I do this?? How??
>
> I know that rowid exists, but it is a number very stranger and I not
>understand it.
>
> Can anybody help me???
>
> PD: I works in Livewire at UNIX platform and Oracle database. Does
>anyone knows if in Livewire this is posible??
>
> Thanks in advance!!!
>

select *
from (select rownum ALIAS

        ,      t1.* 
        from   table t1 ) t2

where t2.ALIAS = 500;

Wessel van Alphen

(Please remove X's from e-mail account when replying) Received on Wed Jul 08 1998 - 05:49:12 CDT