title: How to Finding Random records which are not available in the table after deleted ?is it possible to find out?
body: <p>I have table called Student and table columns are Id(identity Key) &amp; student Name. It having 100 records from 1 to 100.I deleted randomly 5 records from the student table. Now the table having only 95 records. How do I get logic what are the 5 id's not available in the table. Can anyone help to figure out the correct query?
  I tried to write query by fetching the records every records id is increasing &quot;1&quot; in the loop if any record not matched that records would go to temp  table and then loop will continues until last record 100th. The interviewer said it was not correct way and didn't tell anyway to find out. I am confused whether it is possible or not.</p>