Sometimes we all need to insert multiple rows into our database. Data can come from various sources like feeds, excel sheets etc.
So how to do that?
Goal: Insert multiple rows in efficient way.
SQL
How to select rows which doesn’t exist in other table in SQL
StandardWe all are familiar with selecting the rows which has common data in multiple tables. And yes using joins are the most popular solution among the developers.
Now question is how to select rows which doesn’t exists in other tables.
lets say there are two tables employee and department.
TECH ON RIA - Shubham's Blog 