Database

Mycroft Holmes wrote:

also what is a lak

select * from (
  select top 10000 *, row_number() over (order by rownum) as rn
  from productlist
) t
where rn between 9990 and 10000

SELECT  *
FROM    (
    SELECT  *
    FROM    Productlist pl
    ORDER BY somefield
    )
WHERE   ROWNUM BETWEEN 9991 AND 10000

select *  
from ProductList a,
     (select b.Id, 
             count(*) over (order by b.Id) as runcount
      from   productlist b
      where  b.Id > :lastFetchedId) subq
where a.Id = subq.Id
and   subq.runcount <= 10

Nanda_MR wrote:

I am adding rownum

...VALUES('"+ text +"')"...
          ^          ^

hr = rec2->Open("INSERT INTO mytable(id)VALUES('"+ text +"')",con2.GetInterfacePtr(), ADODB::adOpenForwardOnly, ADODB::adLockReadOnly, ADODB::adCmdText);