SQL JOINS Tutorial Using a Case Study | SQL Fundamentals |Join explanation using Superstore Dataset

[@NatureAndTravelAndAnimals]

Clear explanation bro and I appreciate your efforts in making videos on SQL

[@ankitbansal6]

Glad to know 🙂

[@saradakv]

Excellent video! I was in time crunch and have always got confused with joins. Saw your video, not just understood but feel confident about the concept! Thanks a ton!!

[@ankitbansal6]

Great to hear!

[@Learner_attitude]

Superb ankit bhaiya all 4 joins easily understood but fear about self join ,normalization ,subquery

[@shauryaverma8780]

The best till date, thank you so much !!!!

[@ankitbansal6]

Glad it helped!

[@sauravips]

fantastic explanation brother

[@SuperMohit95]

Great refresher on Joins!

[@pavitrashailaja850]

Very clearly explained 🙏🏻

[@ankitbansal6]

Glad you liked it ☺️

[@SumanGhosh-vn3tx]

Very Infrormative.Thanks a ton!!

[@ankitbansal6]

Good to know 😊

[@utkarshdixit3502]

Beautiful explanation

[@ankitbansal6]

Thank you 😊

[@shashankdhandharia4175]

Great explanation
Instead of coalesce function can we use IFNULL function?

[@ankitbansal6]

If it's there in your database you can use. Moreover ifnull will take only 2 arguments while coalesce can have many..

[@vatsalvasavada136]

HI Ankit great video. where I can find DDL for this exercise?

[@adityaanand1591]

it's really a good explanation with example..Is there any complete tutorial of yours on SQL.

[@ankitbansal6]

Thanks Aditya. I am planning to create a playlist zero to hero. Stay tuned.

[@adityaanand1591]

@@ankitbansal6 Thanks, I am curious for that playlist. The way you have explained the JOINS through a case study is really very helpful. So, also try to make your playlist with such type of case study for complete course.

[@swatisingh-yw1fw]

sir i am not able to import excel file in sql server please in the beginning tell how to get dataset in sql server.

[@sudarshanthota4444]

Could you please upload video on removing dupilcates using queries...

[@ankitbansal6]

Sure will do that.

[@sudarshanthota4444]

@@ankitbansal6 please make video on above mentioned order's and return data for removing dupilcates..

[@ankitbansal6]

@@sudarshanthota4444 You want to delete duplicates from table or just return data without duplicates

[@sudarshanthota4444]

@@ankitbansal6I want delete the dupilcates

[@ankitbansal6]

@@sudarshanthota4444 ok

[@jyotsanapandey978]

I have downloaded the dataset from the description by it still shows the all rows and columns (9994) the given dataset do have duplicate values. What should i do now???

[@sunnysharma5402]

do remove duplicate only on Order_ID columns in Superstore_Orders . It will be 5009 Orders. This will fix your problem

[@deepthimurali962]

I have imported the superstore dataset from the drive link posted in description and removed duplicates using the below query. Is the query right?
with CTE_remove_dup as
(SELECT r.*,
ROW_NUMBER() OVER ( PARTITION BY order_id ORDER BY order_id desc) AS RN
FROM [dbo].[returns] r )
DELETE from CTE_remove_dup
WHERE RN > 1
with CTE_remove_dup as
(SELECT s.*,
ROW_NUMBER() OVER ( PARTITION BY order_id ORDER BY row_id desc) AS RN
FROM [dbo].[superstore_orders] s )
DELETE from CTE_remove_dup
WHERE RN > 1

[@ankitbansal6]

Looks good 🙂

[@chetanpatil1266]

Thank you

[@abhimanyutiwari100]

Thanks, can you tell what is the dateype to store "mm/dd/yyyy" as mentioned in your video. I am using DATE data type to create ship_date column.

[@ankitbansal6]

You can store mm/dd/yyyy in a date data type column..

[@swatisingh-yw1fw]

sir how to add excel file to sql?