i want to insert buy or sell value if the value of 10th record of (close)column is greater then 9th record of(refrance) then insert value buy otherwise sell

See more:

ASP.NET

i want to insert value in table 'buy' or 'sell' value
if the value of 10th record of (close)column is greater then 9th record of(refrance) column then insert value buy otherwise sell


how can i do this?

[EDIT from CHill60]
I'm adding some pertinent information to the OP's question and deleting my solution.

Quote:

i have a table there have a (open, high, low, close, ref)column n 4000 rows
i want that if close column value is greater then ref value then print buy otherwisw sell
& i want to do this for all 4000 rows

Quote:

I dnt want to select i want to insert buy or sell value
if the value of 10th record of (close)column is greater then 9th record of(refrance) then insert value buy otherwise sell

Quote:

m using access database 2010 n asp.net 2010