SQL update top1 row query

Question

The query below is working:

update  top(1) ShipBillInfo  set     shipfirstname='kkk'  where   CustomerId='134'; 

but it is showing error if i try to order by some Id: for example:

update  top(1) ShipBillInfo  set     shipfirstname='kkk'  where   CustomerId='134'  order by          OredrGUID desc; 

Answer 1

With cte as ( select  top(1) shipfirtsname   From ShipBillInfo  where   CustomerId='134'  order by  OredrGUID desc) Update cte set shipfirstname='abc'; 

Answer 2

why dont you do :

update ShipBillInfo  set shipfirstname='kkk'  where OrderGUID = (select top (1) OrderGUID                      from ShipBillInfo                     where CustomerId = 134                     order by OredrGUID desc )