monaye/update.sql

Created April 12, 2018 03:04

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/monaye/84f9768010d23844e9faa28a331adc04.js"></script>
Save monaye/84f9768010d23844e9faa28a331adc04 to your computer and use it in GitHub Desktop.

Download ZIP

Update column value based on same table's row of other column value

Raw

	UPDATE
	tableA
	SET
	columnA = SUB.columnB
	FROM
	( select id, columnB FROM tableA ) as SUB
	WHERE
	tableA.id = SUB.id;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment