Re: rownum

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 06 Jan 2005 22:28:34 -0800
Message-ID: <41de2ae3$1_2@127.0.0.1>

fitzjarrell_at_cox.net wrote:

> 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

Surely this was a classroom assignment.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Fri Jan 07 2005 - 00:28:34 CST