select * from emp where rowid in ( select rowid from emp where rownum < &upto
minus
select rowid from emp where rownum <&startfrom)

from this you can select between any range.

suppose emp table is there.

assume that 11th column is ename nth column is some dump column.

now i want to insert the name column into dumpcolum. then simply execute the query.

insert into emp(dump) values select ename from emp

Thanks & Regards

Madhu D.

I assume that you ask how to get data of column X to column N. That is your query should be like select column_11 column_12 column_13 ...column_n from table_A .

But you are not sure about the name of the column which is at place 11 12 and so on...

I hope you can not do this thru normal SQL. But you sould be able to do this using Dynamic SQL. Dynamic SQL lets you to frame your query during run time. so get the total no of column that your table has and go to the column 11 12 etc and finish framing your query. That should be the way.

Pls let me know if anyone knows any other way....

-Maria Antony

Try this

declare @a varchar(1000) @tblname varchar(100) @b nvarchar(1000)
declare @count int @startcount int @i int

select @i 1
@startcount <Starting column no.>
@a ''
@tblname '<table name>'

select @count max(sc.colid) from sysobjects so join syscolumns sc on sc.id so.id where so.name @tblname
select @a sc.name + ' ' + @a from sysobjects so join syscolumns sc on sc.id so.id where so.name @tblname order by sc.colid desc

set @b substring(@a (patindex(' ' @a)+1) len(@a))

while @startcount > @i + 1
begin
set @b substring(@b patindex(' ' @b)+1 len(@b))
set @i @i+1
end

set @b N'select ' + left(@b len(@b)-1) + ' from ' + @tblname

exec sp_executesql @b

You can get the rows from 11 to n(12 13 14 15....) by using foll query-

select * from(select a.* rownum r1 from

(select * from emp order by empno)a

where rownum < &n)

where r1 > 11;

hi

select column _name

from table_name WHERE COLUMN_NAME BETWEEN 11TH ROW and NTH ROW

ORDERBY COLUMN_NAME/