Breaking News: Grepper is joining You.com. Read the official announcement!

sql delete where in select

Add Answer

Rich Raccoon answered on February 20, 2020 Popularity 10/10 Helpfulness 5/10

answer sql delete where in select

related sql delete where in

related delete from where sql

sql delete where in select

Comment

DELETE FROM tableA
WHERE ROWID IN 
  ( SELECT q.ROWID
    FROM tableA q
      INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) OR q.memotext NOT LIKE '%/%/%')
      AND (u.FldFormat = 'Date'));

Popularity 10/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: select sql sql-delete where-in

Link to this answer
Share Copy Link

Contributed on Oct 29 2020

Rich Raccoon

0 Answers Avg Quality 2/10

Closely Related Answers

sql delete where in

Comment

-- Deletes all records where `columnName` matches the values in brackets.
DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 20 2020

SmokeFrog

0 Answers Avg Quality 2/10

delete from where sql

Comment

DELETE FROM my_table;		-- all rows
DELETE FROM my_table WHERE my_id = 12345;
DELETE FROM my_table WHERE my_id IN (SELECT id2 FROM my_table2);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: delete-row record sql where

Link to this answer
Share Copy Link

Contributed on May 02 2021

VasteMonde

0 Answers Avg Quality 2/10

sql delete where in select

Contents

More Related Answers

sql delete where in select

Closely Related Answers

sql delete where in

delete from where sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.