Each time run the query update row one by one in SQL Server

Hi Nurali,

Refer the below query.

--First time run update one row with color green
UPDATE Mixed SET Color = 'Green' 
WHERE Id = (SELECT TOP 1 Id FROM Mixed 
			WHERE ISNULL(Color,'') = (SELECT TOP 1 ISNULL(Color,'') FROM Mixed WHERE ISNULL(Color,'') = '' AND PersonId = 1))
SELECT * FROM Mixed

--Second time run update one row with color yellow
UPDATE Mixed SET Color = 'Yellow' 
WHERE Id = (SELECT TOP 1 Id FROM Mixed 
			WHERE ISNULL(Color,'') = (SELECT TOP 1 ISNULL(Color,'') FROM Mixed WHERE ISNULL(Color,'') = '' AND PersonId = 1))
SELECT * FROM Mixed 

--Third time run update one row with color red
UPDATE Mixed SET Color = 'Red' 
WHERE Id = (SELECT TOP 1 Id FROM Mixed 
			WHERE ISNULL(Color,'') = (SELECT TOP 1 ISNULL(Color,'') FROM Mixed WHERE ISNULL(Color,'') = '' AND PersonId = 1))
SELECT * FROM Mixed 

--Fourth time run update one row with color yellow
UPDATE Mixed SET Color = 'Yellow' 
WHERE Id = (SELECT TOP 1 Id FROM Mixed 
			WHERE ISNULL(Color,'') = (SELECT TOP 1 ISNULL(Color,'') FROM Mixed WHERE ISNULL(Color,'') = '' AND PersonId = 1))
SELECT * FROM Mixed 

Screenshot