- Notifications
You must be signed in to change notification settings - Fork689
Delete
Mathias Wulff edited this pageDec 15, 2025 ·9 revisions
Syntax:
DELETEFROM table [WHERE expression]
Samples:
alasql('DELETE FROM cities WHERE population < 100000');alasql('DELETE FROM star WHERE name LIKE "A%"');alasql('DELETE FROM countries');
To delete all records from table:
alasql('DELETE FROM [Table A]');
To delete only selected records from table:
varnumberOfDeletedLines=alasql('DELETE FROM [Table A] WHERE field1 > 10');
You can use theOUTPUT clause to return the deleted data.
// Return all deleted columnsalasql('DELETE FROM cities WHERE population < 100000 OUTPUT DELETED.*');// Return specific columnsalasql('DELETE FROM cities WHERE population < 100000 OUTPUT DELETED.name, DELETED.population');
ADELETE statement will return the amount of rows deleted by the statment.
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo