Tricky SQL without JOIN Operation🔥 EXISTS For LOOKUP SubQuery !!

[@shashank_mishra]

Suggestion for next topic of SQL ??

[@shivarajhalageri2513]

Hello shashank ,, it's good if you come up with Hive playlist,,

[@aatishsingh7075]

Co-realted subquery

[@Sid-ej3hy]

Actual industrial question related to sql and its solutions

[@debashishbarik4561]

CTE & Recursive CTE

[@vinodpaluvuri54]

explode

[@AhmedAbdurrub]

Some good Data engineering projects for beginners

[@surajbais7533]

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.

[@ankitkirar5598]

Awesome! Shashank , nice explanation

[@sravankumar1767]

Nice explanation, very useful 👍 👌 👏

[@Sid-ej3hy]

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!

[@prabhasaha6030]

Good one

[@pankajdubey1123]

thanks sir this content is new for me..... please launch data scientist course

[@vibekdutta6539]

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?

[@sakshantgongal521]

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

[@rajnandinipadhy2533]

In SQL when we do the join does it include shuffling and do exists operation includes shuffling??

[@ankandatta4352]

Is exist a narrow transformation?

[@surajbais7533]

Nice Sir ji

[@sivasrimakurthi206]

Hi Shashank, would you make video on FRAME clause? this topic I believe cover lot of concepts in SQL

[@rushdafatma2788]

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

[@rose9466]

Can you make videos on how to solve product metrics / case study for data analyst interviews

[@navejpathan]

Hi @Shashank, Performance wise which is better. join or exists? consider I have millions of records.

[@shashank_mishra]

If it is related to lookup then join will be a nightmare for this use case considering million rows

[@ajinkyaadhotre5336]

Hello bhaiya can you please make a video on some good beginner data engineering projects that will make a good impression on recruiters

[@nittinrajput1119]

👍👍

[@margoobalamansari2477]

Apply operator in SQL server

[@Sid-ej3hy]

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!