CODEWITHSUNDEEP
sql
user3518246
user3518246

Reputation: 1

Finding out difference records from two tables

I have 250 records in one table and after extraction into stagging the count is 249 Records, I am missing one record.

how to find out the missing records in SQL SERVER ???

Upvotes: 0

Views: 46

Answers (2)

MikkaRin
MikkaRin

Reputation: 3084

select * from BiggerTable
where BiggerTable.id not in (select id from SmallerTable)

Upvotes: 1

Anthony Horne
Anthony Horne

Reputation: 2522

select
    *
from tableAll
left join TableLess
    on tableAll.ID = TableLess.Id
where
    TableLess.Id is null

Upvotes: 0

Related Questions