Video

I'm from UK 🇬🇧. These videos are a goldmine for data engineers! The real-time SQL use cases were spot on and incredibly relevant to the challenges we face daily. The practical examples and clear explanations make it so much easier to apply these concepts in our projects. Great job! 👏

❤

Well explained 🎉

Tq for sharing bro😊

❤❤❤❤

😊❤😊

Excellent Explanation rajinkanth garu

🎉🎉❤🎉🎉

Good explanation rajini😊

Very good explanation 👍🏽

Very good explanation

with col_transformed as ( select *, (len(name) - len(replace(name,' ',''))) as checker, CHARINDEX(' ',name) as first_space, CHARINDEX(' ',name,CHARINDEX(' ',name)+1) as second_space from test_names ) select name, case when checker = 0 then name else SUBSTRING(name,1,first_space-1) end as first_name, case when checker = 2 then SUBSTRING(name,first_space+1, (second_space - first_space)) else null end as middle_name, case when checker != 0 then case when checker = 1 then SUBSTRING(name,first_space+1, (len(name)-first_space)) else SUBSTRING(name,second_space+1, (len(name)-second_space)) end else null end as last_name from col_transformed;

🎉🎉❤🎉🎉

❤

WITH cte AS ( SELECT customer_name, TRIM(value) AS part, ROW_NUMBER() OVER (PARTITION BY customer_name ORDER BY (SELECT 1)) AS rn FROM customers CROSS APPLY STRING_SPLIT(customer_name, ' ') ) SELECT customer_name, MAX(CASE WHEN rn = 1 THEN part END) AS first_name, MAX(CASE WHEN rn = 2 THEN part END) AS middle_name, MAX(CASE WHEN rn = 3 THEN part END) AS last_name FROM cte GROUP BY customer_name;

🎉🎉🎉❤🎉🎉🎉

❤

to viewers : while watching this video just take break for every 3 minutes and prepare a notes on this concept...and iam sure u guys won't forget in your life time....

🎉❤🎉

🎉🎉❤🎉🎉

very good question...Keep posting such questions and i will keep liking & share your channel....But please 1 video in every 2 day.or else every day post new & quality level questions...👍👍👍👍

❤

Please provide create & insert statement in the description box for every video.

I like your approach to make others understand after writing each query and that too step by step in excel...Great keep it up....looking forward to see 1 video in every two days.....Please bring quality level sql questions.👍👍

🎉🎉❤🎉🎉

❤

❤

😊❤😊

Thanks for sharing. Here's my approach on SQL server: =========================================== with cte2 as (select *, ROW_NUMBER() over(partition by name order by (select 1)) rn from names cross apply string_split(name,' ')) select Max(First_name) First_name, Max(Middle_name) Middle_name, Max(Last_name) Last_name from (select *, case when rn = 1 then value end as First_name, case when COUNT(name) over(partition by name) > 2 and rn = 2 then value end Middle_name, case when COUNT(name) over(partition by name) < 3 and rn = 2 then value when COUNT(name) over(partition by name) >= 3 and rn = 3 then value end Last_name from cte2) s1 group by name ===========================================

🎉🎉❤🎉🎉

❤

Clear cut explanation sir👏

❤

🎉❤🎉

with cte as( select team_1, count(*) as total_matches from (select team_1 from icc union all select team_2 from icc) group by 1 ), cte1 as( select c.team_1, i.winner , count(case when c.team_1=i.winner then c.team_1 else null end) as won from cte c left join icc i on c.team_1=i.winner group by 1,2 ), cte2 as( select c.team_1,c.total_matches,c1.won, (c.total_matches - c1.won) as loss from cte1 c1 left join cte c on c.team_1=c1.team_1 ) select *, (won*2) as total_points from cte2 order by 5 desc

❤

❤

🎉❤🎉

-----------My Solution in Oracle ------------------------------ SELECT trim(substr('DATA', LEVEL,1)) str_2_tab FROM dual CONNECT BY LEVEL <= length('DATA') ; Output : str_2_tab D A T A

💓

Nice explanation Sir

❤❤

Super explanation bro..

💓

❤🎉🎉❤

🎉🎉❤🎉🎉

💓

🎉🎉❤🎉🎉