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 (IDval) VALUES ('1''q') INSERT INTO dbo.TestTableA (IDval) VALUES ('2''s') INSERT INTO dbo.TestTableA (IDval) VALUES ('3''s') CREATE TABLE dbo.TestTableB ( ID varchar(1)  val varchar(1) ) INSERT INTO dbo.TestTableB (IDval) 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 .