Friday, 30 September 2022

sql remove not existing ids in table one

How to Delete Rows That do not Exist in Another Table


 select a.orderid from web.orderHeader a

 WHERE web.orderHeader.orderid NOT IN (SELECT f.orderid 

                        FROM web.orderdetail f)

Using NOT IN:

DELETE FROM orderHeader
 WHERE orderid NOT IN (SELECT f.orderid 
                        FROM orderdetail f)

Using NOT EXISTS:

DELETE FROM orderHeader
 WHERE NOT EXISTS(SELECT NULL
                    FROM orderdetail f
WHERE f.id = fileid)

No comments:

Post a Comment

remove duplicates in an sorted array

  using System; public class HelloWorld {          public static void Main(string[] args)     {         int[] ar={2,2,3,3,4,6,6};          C...