Database

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); 

AhmedMasum wrote:

Suppose some one purchased a ticket online. [Here the value of a column is pending]
If the person does not pay the cash money within 24 hours than the ticket will be automatically cancelled. [The value of the status column will be cancelled after 24 hours]

AhmedMasum wrote:

How can I do automatic update of a table after 24 hours???

I are Troll