Mostly we use the join operator and use the distinct key word to fix the duplicate but using exists operator it is more reliable to use and next time we have to appear distinct records then we can use exists operator because it's show unique output which is exists in another table.
Hi , as your most of the videos are for Business and Data Analysts You can cover the actual (SQL ,Case Study and Guesstimate) Questions in your videos as a series, with question and answer. It will be very helpful!
I wouldnt even think of Join even if I hadn't known about Exists. I'd just find out the ID from the Customer table and check if its IN the orders table. Would that be of the same complexity as Exists?
Hello sir I'm your new subscriber and I like your content ... Sir i have done mca in 2013 and 8 years of teaching experience and now I want to switch to an IT company and I don't have programming knowledge even i don't have good grades in 10 12 so how can I find a good job and which course and skill good for me
Hi , as your most of the videos are for Business and Data Analysts You can cover the actual (SQL ,Case Study and Guesstimate) Questions in your videos as a series, with question and answer. It will be very helpful!
Suggestion for next topic of SQL ??
Hello shashank ,, it's good if you come up with Hive playlist,,
Co-realted subquery
Actual industrial question related to sql and its solutions
CTE & Recursive CTE
explode
Mostly we use the join operator and use the distinct key word to fix the duplicate but using exists operator it is more reliable to use and next time we have to appear distinct records then we can use exists operator because it's show unique output which is exists in another table.
Some good Data engineering projects for beginners
Awesome! Shashank , nice explanation
Nice explanation, very useful 👍 👌 👏
Hi , as your most of the videos are for Business and Data Analysts
You can cover the actual (SQL ,Case Study and Guesstimate) Questions in your videos as a series, with question and answer.
It will be very helpful!
thanks sir this content is new for me..... please launch data scientist course
I wouldnt even think of Join even if I hadn't known about Exists. I'd just find out the ID from the Customer table and check if its IN the orders table. Would that be of the same complexity as Exists?
Hi Shashank, would you make video on FRAME clause? this topic I believe cover lot of concepts in SQL
make one on Windows Functions and can u please make a video on what type of SQL queries ask in Data Analyst Interview for Entry Level position
In SQL when we do the join does it include shuffling and do exists operation includes shuffling??
Good one
Can you make videos on how to solve product metrics / case study for data analyst interviews
Is exist a narrow transformation?
Nice Sir ji
Hello bhaiya can you please make a video on some good beginner data engineering projects that will make a good impression on recruiters
👍👍
Hello sir I'm your new subscriber and I like your content ... Sir i have done mca in 2013 and 8 years of teaching experience and now I want to switch to an IT company and I don't have programming knowledge even i don't have good grades in 10 12 so how can I find a good job and which course and skill good for me
Hi @Shashank, Performance wise which is better. join or exists? consider I have millions of records.
If it is related to lookup then join will be a nightmare for this use case considering million rows
Apply operator in SQL server
Hi , as your most of the videos are for Business and Data Analysts
You can cover the actual (SQL ,Case Study and Guesstimate) Questions in your videos as a series, with question and answer.
It will be very helpful!