Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Sql Query Not Exist

Home
Forums

Sql Query Not Exist

Vedant

11yAsked Oct 4, 2015, 5:57 AM1.2k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Sujeet Suman11y ago
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.
Priyaranjan K S11y ago
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