D.Millin
Reputation: 69
Decrease value in a number column using a query
I'm looking to create an SQL query which will decrease a value in a column by 1 every time it is ran.
Simple Table with 3 columns -
Name - Number - Created
Dan 20 20/03/2019
I want to decrease the Number by one every time I run the query.
Upvotes: 0
Views: 757
Answers (1)
Related Questions
- Oracle SQL - Update column data using MINUS operator
- Update numbers with a counter in SQL
- PL SQL - Sequentially update only number in varchar
- Updating only specific rows within the lowest value
- Updating a number column with a new string of numbers starting at particular number
- Oracle - how to update table column by subtracting a value in a subquery?
- Consecutively update values starting from a number in the table SQL
- Mysql query: decrease value by 1
- update query to change value for specific row
- How to increase non-numeric column value?