Forum OpenACS Development: Re: How do I get first half rows from ORACLE table

Collapse
7: Re: How do I get first half rows from ORACLE table (response to 1)
Posted by Vamshi Krishna Kaniganti on 11/19/03 12:55 PM
insert into newly_acquired_stocks
        select * from my_stocks
        where rownum < = (select count(*)/2 from my_stocks);

this will work out check it out