Write a postgre SQL statement to change the email and commission_pct column of the employees table with 'not available' and 0.10 for all employees
- Postgre SQL
- 2021-09-29
- mhanasmh00489829403
الأجوبة
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
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة