Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/delete_top.sql

Created June 12, 2021 21:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bartubozkurt/6fa9b2e60634c66f82b0d8ce2c1f8272 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bartubozkurt/6fa9b2e60634c66f82b0d8ce2c1f8272 to your computer and use it in GitHub Desktop.
Download ZIP
Example would delete the first 3 records from the employees table where the last_name is 'Johnson'.
Raw
delete_top.sql
DELETE TOP (3) FROM Customers WHERE last_name = ‘Johnson’;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment