Updating a List of Numbers | Dataford Interview Questions

How would you update a list of numbers in SQL?

Use the number_list table. Update every negative number_value to 0; leave zero, positive, and NULL values unchanged.

Output

number_list

Column	Type	Description
idPK	INTEGER	Unique identifier for the list entry
number_value	INTEGER	Number that may need to be updated

Your question is Updating a List of Numbers. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

How would you update a list of numbers in SQL?

Use the number_list table. Update every negative number_value to 0; leave zero, positive, and NULL values unchanged.

number_list

Column	Type	Description
idPK	INTEGER	Unique identifier for the list entry
number_value	INTEGER	Number that may need to be updated

Your question is Updating a List of Numbers. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.