SQL Interview Questions and answers Part 24 | How to find missing rows in SQL
SQL Interview Questions and answers Part 24 | How to find missing rows in SQL | SQL Scenario based Interview Question and Answer
Input :- Sample Table has ID column which is not continuous value starting from 1 to 20
Problem Statement :- Write a SQL to find the missing ID From sample Table
Follow me on Social Networking Sites :
*Twitter:
/ sunilkr5672
*Instagram :
/ itjunction4all
Table Script
------------------------------
Create Table Sample_Table(
ID int)
Insert into Sample_Table Values (1),(4),(7),(9),(12),(14),(16),(17),(20)
#SQLInterviewQuestionsandanswers #sqlInterviewQuestions #sqlInterviewQuestionsForTesting #sqlInterviewQuestionsQuery #sqlInterviewQuestionsOnJoins #sqlTechnicalInterviewQuestions
#SQLforETLTesters #CommonSqlInterviewQuestions #ETLTesting