Hi All, This video is for beginner who is planning to get a job in the data field. If you're a person who is having some good experience and planning to revise the topics then please increase speed of the video. Thanks

Informative ❤ and subscribed

@suriyas_zone

14 күн бұрын

@@amarpc3532 thank you ❤️

Amazing sir Thanks for sharing ❤

@suriyas_zone

2 ай бұрын

Thank you. Please do share and subscribe 🎉

Great effort. Keep it up

@suriyas_zone

Ай бұрын

Thank you Nishant ☺️ Please share

Informative

@suriyas_zone

4 ай бұрын

Thanks ! Please do share with your friends. Videos will be uploaded weekly once !

Sir.. really useful 🎉

@suriyas_zone

4 ай бұрын

Thank you

WHERE (rn = 50); I prefer this

@suriyas_zone

28 күн бұрын

@@ogunniransiji2686 great

with cte as( select Category, SubCategory, cast(Price as signed) as price_int from Category), cte2 as ( select Category, SubCategory, price_int, rank() over(partition by Category order by price_int desc) as rnk, count(Category) over(partition by Category) as total_cnt from cte) select * from cte2 where rnk 1 then 2 when total_cnt = 1 and price_int >= 50 then 1 end )

@suriyas_zone

4 ай бұрын

Great

with cte as (select * from (select *,dense_rank()over(partition by category order by price) dk from category)x where dk50 then 'yes' else 'no' end as flag from b )m where flag='yes';

@suriyas_zone

4 ай бұрын

Great

Nice bro

@suriyas_zone

Ай бұрын

Thank you bro

select category,subcategory from ( select *,rank() over(partition by category order by cast(price as money) desc) as rn from category ) as a where rn50

@suriyas_zone

Ай бұрын

It will give the category which has single subcategories and also if it's price is less than 50. Good try...keep practicing!

Sir window functions full explanation video podunga

@suriyas_zone

4 ай бұрын

Sure

Pleas share more with SQL scenarios pls

@suriyas_zone

4 ай бұрын

Sure. Weekly once video will be uploaded

My Solution :) with cte as (select *, dense_rank() over (partition by category order by price desc)dr , count(*) over (partition by category)cnt_category from category) select category, subcategory from cte where cnt_category = 1 and price > 50 union select category, subcategory from cte where cnt_category > 1 and dr

@suriyas_zone

Ай бұрын

Great

Hai can we get job in Data Engineer role as a fresher

@suriyas_zone

4 ай бұрын

Hi, Yes for sure. Definitely, a fresher can get a job as data engineer. But, many companies will not offer directly. I would recommend you to learn SQL, python, story telling, basics of data modelling, basics of Excel initially to get a job as a data analyst full-time or for the intern.. Get into the field first and try for a data engineer by learning, spark/Hadoop/hive (spark will be my choice) and one cloud. Keep an eye on my KZread Channel to learn more about SQL, data modelling and python.

@user-wg4bh3rv5i

4 ай бұрын

Thank you so much @@suriyas_zone

correct me if i am wrong. --query: with cte1 as ( select category, subcategory, price, rank() over(partition by category order by price) rnk from category ) select category, subcategory from cte1 where rnk in (1,2) --output: CATEGORY SUBCATEGORY Biscuits Oreo Chips Bingo Chips Lays Choclate Dairy Milk Choclate Perk

@suriyas_zone

Ай бұрын

Hi Piyush, Your query won't give expected results. It will give all the subcategories based on the rank(1,2) which you've generated based on category and price. What will happen if the price is less than 50 ?

Find my approach below. select category,subcategory from ( select c.*, case when count(*) over(partition by category)=1 and price

@gouravbhatt5099

2 сағат бұрын

Shouldn't the price have >=50 in this query ? select category,subcategory from ( select c.*, case when count(*) over(partition by category)=1 and price>=50 then 0 else dense_rank()over(partition by category order by price desc) end rk from category c ) where rk

Hi bro., Very informative and impressive content Love to connect with you May I know your LinkedIn Id

@suriyas_zone

10 күн бұрын

@@roobanj9432 Please find the link below: www.linkedin.com/in/suriya-senthilkumar-3a069118b?