OraFAQ Forum: Server Administration

Mon, 18 December 2000 06:45

srikantha
Messages: 3
Registered: December 2000

Junior Member

how to display the alternative records of the table in the sql.

Mon, 18 December 2000 08:42

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

select * from
(select rownum rnum, col1, col2 from t1)
where mod(rnum, 2) = 0
/

Previous Topic:	Connection string
Next Topic:	Connect on database

Goto Forum:

]

Current Time: Sat May 04 13:04:44 CDT 2024