Sql Query Not Exist

Question

sql query for getting row which is not exist in second data table .

Priyaranjan K S · Answer

Hi Vedant, Below query should help you. I have mentioned 2 options . CREATE TABLE dbo.TestTableA ( ID varchar(1) , val varchar(1) ) INSERT INTO dbo.TestTableA (ID,val) VALUES ('1','q') INSERT INTO dbo.TestTableA (ID,val) VALUES ('2','s') INSERT INTO dbo.TestTableA (ID,val) VALUES ('3','s') CREATE TABLE dbo.TestTableB ( ID varchar(1) , val varchar(1) ) INSERT INTO dbo.TestTableB (ID,val) VALUES ('1','q') --Option 1 SELECT * FROM TestTableA WHERE ID NOT IN (SELECT ID FROM TestTableB) --Option 2 SELECT * FROM TestTableA LEFT OUTER JOIN TestTableB ON (TestTableA.ID = TestTableB.ID) WHERE TestTableB.ID IS NULL Drop table TestTableA Drop table TestTableB Thanks, Priyan If you found this useful Please mark this as Answer

Sujeet Suman · Answer

Vedant please once try below query: SELECT * FROM DB_Table02 tb02 WHERE NOT EXISTS (SELECT * FROM DB_Table01 tb01 WHERE tb01.ID = tb02.ID) If this is helpful for you then please accept my Answer .

Sql Query Not Exist

Answers (2)