Decrease salary using a SQL query

by

I’m making lots of assumptions since your question doesn’t have much detail. Here is some generic code assuming that everything is in 1 table: 

Update employees
set salary = salary * .85 
where training_course_completed < '2012-11-15' 
and start_date > '2013-02-05'
;

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. SQL JOIN – WHERE clause vs. ON clause
  3. How to convert comma separated values to rows in oracle?
  4. How do I see what character set a MySQL database / table / column is?
  5. How do I create a comma-separated list using a SQL query?
  6. How to list table foreign keys
  7. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  8. Group by column and multiple Rows into One Row multiple columns
  9. Is it possible to output a SELECT statement from a PL/SQL block?
  10. Performing SQL queries on an Excel Table within a Workbook with VBA Macro
  11. Accessing SQL Database in Excel-VBA
  12. Primary key or Unique index?
  13. Find the smallest unused number in SQL Server
  14. Dynamic Sorting within SQL Stored Procedures
  15. Is it possible to have an indexed view in MySQL?
  16. Django select only rows with duplicate field values
  17. Why can’t you mix Aggregate values and Non-Aggregate values in a single SELECT?
  18. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  19. What are the principles behind, and benefits of, the “party model”?
  20. How to find rows in one table that have no corresponding row in another table
  21. I want to use CASE statement to update some records in sql server 2005
  22. PostgreSQL delete with inner join
  23. Display names of all constraints for a table in Oracle SQL
  24. Sql Server trigger insert values from new row into another table
  25. Getting the Id of a row I updated in Sql Server
  26. Zero SQL deadlock by design – any coding patterns?
  27. UNION ALL vs OR condition in sql server query
  28. Convert bigint to datetime
  29. Drop column from SQLite table
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment