DBI202Xuất hiện trong 1 đề thi
The following SQL updates the first employees (empID = 1) with a new empName and a new City from employees table.
Các lựa chọn
A```sql
UPDATE employees
SET empName = 'Alfred Schmidt' AND City = 'Frankfurt'
WHERE empID = 1;
```
B```sql
UPDATE employees
SET empID = 1
WHERE empName = 'Alfred Schmidt' AND City = 'Frankfurt';
```
C```sql
UPDATE employees
SET empName = 'Alfred Schmidt', City = 'Frankfurt'
WHERE empID = 1;
```
D```sql
UPDATE employees
SET empID = 1
WHERE empName = 'Alfred Schmidt', City = 'Frankfurt';
```