Re: rownum

db2group88_at_yahoo.com wrote:
> so if i want to do a insert into a new table where data is from
another
> table from row 2 to row 10, what should be right query?

insert into mynewtable
select a.col1, a.col2, a.col3, a.col4 from (select rownum rn, col1, col2, col3, col4 from mytable) a where a.rn between 2 and 10;

Substitute the proper columns from your source table (all of them) for the col1, col2, col3, col4 placeholders in BOTH queries. David Fitzjarrell Received on Thu Jan 06 2005 - 10:48:13 CST