- i have one table transaction
and there are 3 rows i want update only one row
| debit | Voucher no |
|---|---|
| 4000 | cp/1 |
| 3000 | cp/2 |
| 200 | cp/3 |
update values of 3000 sql
UPDATE transac SET CID =
(SELECT CID FROM CUSTOMER WHERE NAME = ‘CASH’),CREDIT = 12 ,DATE =CONVERT(date, ’13-02-2014′, 105),VCHTYPE =’PAYMENT’,SID = (SELECT SID FROM CUSTOMER WHERE NAME = ‘MANOJ’) WHERE TID = (SELECT MAX (TID) FROM transac
WHERE VOUNO = 201)
New contributor
Rajnish Pandey is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.