Top "Sql-delete" questions

Deleting duplicates rows from redshift

I am trying to delete some duplicate data in my redshift table. Below is my query:- With duplicates As (…

sql amazon-redshift sql-delete

Delete, Truncate or Drop to clean out a table in MySQL

I am attempting to clean out a table but not get rid of the actual structure of the table. I …

mysql sql-delete sql-drop

MySQL Injection - Use SELECT query to UPDATE/DELETE

I've got one easy question: say there is a site with a query like: SELECT id, name, message FROM messages …

mysql security select code-injection sql-delete

delete rows from multiple tables

I'm trying to use SQL to delete multiple rows from multiple tables that are joined together. Table A is joined …

mysql delete-row sql-delete

Deleting a row based on the max value

How can I structure a mySQL query to delete a row based on the max value. I tried WHERE jobPositonId = …

mysql sql max sql-delete mysql-error-1093

Postgresql delete multiple rows from multiple tables

Consider 2 or more tables: users (id, firstname, lastname) orders (orderid, userid, orderdate, total) I wish to delete all users and …

sql database postgresql relational-database sql-delete

How to delete by row number in SQL

I need to delete from row number 475 to 948 due to them being duplicates of rows 1-474. It would be something …

ssms sql-delete

Delete SQLite Row with where clause with multiple clauses

I've been searching around and not managed to find a solution or working example so here goes. I've set up …

android sqlite where-clause sql-delete

PostgreSQL DELETE FROM (SELECT * FROM table FETCH FIRST 10 ROWS ONLY)

How do I delete only a few rows in postgreSQL? I want to fetch 10 rows to delete in a subquery. …

postgresql subquery sql-delete

I want a trigger to DELETE from 2 tables in MySQL

I have 3 MySQL tables (food, apple, and orange). I want to delete rows from: apple(idapple, iduser, name) orange(idornge, …

mysql triggers sql-delete