Skip to content
Advertisement

Editing the data

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;

enter image description here

Advertisement

Answer

UPDATE Players.Rank SET Rounds = NULL WHERE Rounds = '9th'
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement