bartubozkurt/delete_exist.sql

Created June 12, 2021 21:35

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

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

Download ZIP

This SQL Server DELETE example would delete all records in the employees table where there is a record in the contacts table whose contact_id is less than 100, and the contact_id matches the employee_id

Raw

delete_exist.sql

	DELETE FROM employees
	WHERE EXISTS
	( SELECT *
	FROM contacts
	WHERE contacts.contact_id = employees.employee_id
	AND contacts.contact_id < 100 );

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