PostgreSQL Update Table: Change the value of more than one column with user defined content

2. Write a SQL statement to change the email and commission_pct column of the employees table with 'not available' and 0.10 for all employees.

Sample table: employees

Sample Solution:

Code:

UPDATE employees SET email='not available',
commission_pct=0.10;

Output:

See the result. Only two rows have been displayed.

postgres=# SELECT * FROM employees LIMIT 2;
 employee_id | first_name | last_name |     email     | phone_number | hire_date  |  job_id  | salary  | commission_pct | manager_id | department_id
-------------+------------+-----------+---------------+--------------+------------+----------+---------+----------------+------------+---------------
         128 | Steven     | Markle    | not available | 650.124.1434 | 1987-07-15 | ST_CLERK | 2200.00 |           0.10 |        120 |            50
         129 | Laura      | Bissot    | not available | 650.124.5234 | 1987-07-16 | ST_CLERK | 3300.00 |           0.10 |        121 |            50

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement to change the email column of the employees table with 'not available' for all employees.
Next: Write a SQL statement to change the email and commission_pct column of the employees table with 'not available' and 0.10 for those employees whose department_id is 110.