Updating Tables in SQL | Dataford Interview Questions

How would you update a table in SQL?

Write a PostgreSQL query that updates existing rows in a table. Keep the answer focused on the basic update pattern and how to target the correct rows.

Output

Update the specified rows in the table.
Return the updated row values if needed.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
full_name	VARCHAR(100)	Employee name
department	VARCHAR(50)	Employee department
salary	INT	Current annual salary
status	VARCHAR(20)	Employment status

Your question is Updating Tables in SQL. 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.

Problem