Adam Strudwick
Adam Strudwick

Reputation: 13129

How to do divide column values in SQL update?

What is the correct syntax to do a SQL Update on a column and divide its values by 1 000 000?

Upvotes: 15

Views: 34697

Answers (1)

Steve Prentice
Steve Prentice

Reputation: 23514

UPDATE table SET column = column / 1000000

Upvotes: 36

Related Questions