Results for “remove row”
Small, practical examples. Search by task or narrow things down below.
Remove dependent rows with a declared cascade
SQL: ON DELETE CASCADE removes children when their referenced parent is deleted.
SQL✓ Tested
Remove dependent rows with a declared cascade
SQL Server: ON DELETE CASCADE removes children when their referenced parent is deleted.
SQL Server✓ Tested
Remove dependent rows with a declared cascade
Postgres: ON DELETE CASCADE removes children when their referenced parent is deleted.
Postgres✓ Tested
Remove dependent rows with a declared cascade
SQLite: ON DELETE CASCADE removes children when their referenced parent is deleted.
SQLite✓ Tested
Delete one matching row
Remove a selected record and inspect what remains.
DELETE✓ Tested
Combine matching rows with INNER JOIN
Read product names with their matching stock values.
INNER JOIN✓ Tested
Count rows per category
Aggregate rows sharing the same category.
GROUP BY✓ Tested
Filter rows with WHERE
Keep products below a chosen price.
WHERE✓ Tested
Find rows shared by two query results
SQL: INTERSECT compares complete selected rows and removes duplicates.
SQL✓ Tested
Find rows shared by two query results
SQL Server: INTERSECT compares complete selected rows and removes duplicates.
SQL Server✓ Tested
Find rows shared by two query results
Postgres: INTERSECT compares complete selected rows and removes duplicates.
Postgres✓ Tested
Find rows shared by two query results
SQLite: INTERSECT compares complete selected rows and removes duplicates.
SQLite✓ Tested