Easy
Given the following 'employees' table:
| emp_id | first_name | last_name | salary |
|--------|------------|-----------|--------|
| 1 | John | Doe | 5000 |
| 2 | Jane | Smith | 5500 |
| 3 | Alice | Johnson | 6000 |
Which SQL query increases the salary of all employees by 10%?
Author: Vincent CotroStatus: PublishedQuestion passed 2631 times
Edit
5
Community Evaluations
Hind
28/08/2024
UPDATE employees : Cette commande indique que vous souhaitez modifier des données dans la table employees.
SET salary = salary * 1.1 : Cette partie de la requĂȘte spĂ©cifie que la colonne salary doit ĂȘtre mise Ă jour en la multipliant par 1.1 (ce qui correspond Ă une augmentation de 10%).
41
Write a SQL query to retrieve the list of employees with a salary greater than 5100.16
Which SQL keyword is used to sort the result of a SELECT statement?16
Update a column in an SQL table19
Select only distinct values in a column using SQL17
Write a SQL query to insert data into a table11
Write the SQL query to delete a column from a table11
How to delete an SQL table?