In the picture, you will see a table at the beginning that contains NULL in the Rounds column. After that, it shows 9th. How can I edit the data from 9th to NULL?
SELECT TOP (1000) [Rank] ,[Player] ,[Team] ,[Position] ,[Rounds] FROM [Yahoo Fantansy Basketball 2020-2021].[Players].[Rank] ORDER BY [Rank] ASC;
Advertisement
Answer
UPDATE Players.Rank SET Rounds = NULL WHERE Rounds = '9th'