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 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.
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
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???
![เปิด อาณาจักร หมื่นล้าน "สาระตั้ม" l [Nickynachat]](http://i.ytimg.com/vi/3XE0nPF4YkQ/mqdefault.jpg)
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!!
Great to hear!
Clear explanation bro and I appreciate your efforts in making videos on SQL
Glad to know 🙂
The best till date, thank you so much !!!!
Glad it helped!
Great refresher on Joins!
fantastic explanation brother
Very Infrormative.Thanks a ton!!
Good to know 😊
Very clearly explained 🙏🏻
Glad you liked it ☺️
Beautiful explanation
Thank you 😊
Great explanation
Instead of coalesce function can we use IFNULL function?
If it's there in your database you can use. Moreover ifnull will take only 2 arguments while coalesce can have many..
HI Ankit great video. where I can find DDL for this exercise?
it's really a good explanation with example..Is there any complete tutorial of yours on SQL.
Thanks Aditya. I am planning to create a playlist zero to hero. Stay tuned.
@@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.
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
Looks good 🙂
Thank you
sir i am not able to import excel file in sql server please in the beginning tell how to get dataset in sql server.
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.
You can store mm/dd/yyyy in a date data type column..
Could you please upload video on removing dupilcates using queries...
Sure will do that.
@@ankitbansal6 please make video on above mentioned order's and return data for removing dupilcates..
@@sudarshanthota4444 You want to delete duplicates from table or just return data without duplicates
@@ankitbansal6I want delete the dupilcates
@@sudarshanthota4444 ok
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???
do remove duplicate only on Order_ID columns in Superstore_Orders . It will be 5009 Orders. This will fix your problem
sir how to add excel file to sql?