Sql Database How Can I Update All The Rows And Set Them To The First "Value1" And Last "Open2" Order By Olddate Within The Same Stockdate

See more:

SQL

dears i am using sql database the columns are as follows :oldDate | stockDate | open | close

how can i update all the rows and set them to the first "close" and last "open" order by oldDate within the same stockdate example:
for stockdate "2014-01-01" the first open is:17.00 and the last close is: 16.910
then i need to update all records that have stockdate:"2014-01-01" and set the close 16.910 and open = 17.0 and so on for every stockDate ...

2014-01-29 17:00:00.680 2014-01-01 00:00:00.000 2014 17.000 17.000
2014-01-30 17:00:00.460 2014-01-01 00:00:00.000 2014 16.800 16.910
2014-02-02 17:00:00.220 2014-02-01 00:00:00.000 2014 16.850 17.000
2014-02-27 17:00:00.247 2014-02-01 00:00:00.000 2014 16.780 16.450
2014-03-04 17:00:00.260 2014-03-01 00:00:00.000 2014 16.700 16.220
2014-03-05 17:00:00.350 2014-03-01 00:00:00.000 2014 15.500 16.200