Re: On Subquery.....

From: Harish Deshpande <harish_at_supersolution.com>
Date: 1997/09/10
Message-ID: <01bcbdb7$69f72280$3f4ef6cc@waconia.supersolution.com>#1/1

Hi satish this code should work
 select A.tel_telecom_id from telecommunications A where (0,A.rowid) in ( select mod(rownum,2),B.rowid from telecommunications B)
/

Bhaskar Acharya

E-Mail : Bacharya_at_Hotmail.com
----------------------------------------------------------------------------
------------------

Satish Narasimha <satish.muc_at_sni.de> wrote in article <34162FD2.DE0_at_sni.de>...
> Hello,
> Can anybody help me how to find an alternate rows in a table..
> using group by operator or any other method....
>
> Satish
> E-Mail : somasatish_at_hotmail.com
>
Received on Wed Sep 10 1997 - 00:00:00 CDT