By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table customerDetails (customerid int, name varchar(20), age int)
insert into customerDetails values (1, 'Mark', null)
insert into customerDetails values (2, 'Ann', null)
UPDATE customerDetails
SET age = 17
ORDER BY customerid DESC
LIMIT 1
select * from customerDetails
customerid | name | age |
---|---|---|
1 | Mark | null |
2 | Ann | 17 |