Пікірлер
@Kirankumar-ml1ro 3 күн бұрын
Please change the data type of the price column to numeric in the create table script in the description. Data was not getting as expected while (order by price desc) for category choclate in PostgreSQL.
@Ravi-oy8zl 16 күн бұрын
At last try to summarise the logic and what you have done. It would be good for learners.
@suriyas_zone 16 күн бұрын
@@Ravi-oy8zl sure, will do that
@roobanj9432 16 күн бұрын
Hi bro., Very informative and impressive content Love to connect with you May I know your LinkedIn Id
@suriyas_zone 16 күн бұрын
@@roobanj9432 Please find the link below: www.linkedin.com/in/suriya-senthilkumar-3a069118b?
@maheshch994 19 күн бұрын
Lot of background noise. Voice clarity required.
@suriyas_zone 19 күн бұрын
Sorry for the inconveniences. Will rectify in the upcoming video
@vineetjain7518 19 күн бұрын
Superb
@suriyas_zone 19 күн бұрын
@@vineetjain7518 Thank you ❤️
@priyankachahande1909 20 күн бұрын
It will help others to build logic
@priyankachahande1909 20 күн бұрын
Keep posting such videos
@suriyas_zone 19 күн бұрын
@@priyankachahande1909 Sure Thank you 😊
@amarpc3532 21 күн бұрын
Informative ❤ and subscribed
@suriyas_zone 21 күн бұрын
@@amarpc3532 thank you ❤️
@logeshc5432 22 күн бұрын
Good effort bro
@suriyas_zone 22 күн бұрын
@@logeshc5432 Thank you bro
@sandhanamurali444 23 күн бұрын
Good effort bro
@suriyas_zone 22 күн бұрын
@@sandhanamurali444 Thank you bro ❤️Please do share and subscribe
@charantej9152 24 күн бұрын
voice is coming clearly
@suriyas_zone 23 күн бұрын
Thank you Charan 😊
@tomshri1453 25 күн бұрын
🌾💥💥
@suriyas_zone 25 күн бұрын
@@tomshri1453 ❤️
@adnanafdalahmed Ай бұрын
nice video! keep it up!
@suriyas_zone Ай бұрын
@@adnanafdalahmed Thank you ❤️
@ogunniransiji2686 Ай бұрын
WHERE (rn <= 2 AND cnt = 2) OR (cnt = 1 AND price >= 50); I prefer this
@suriyas_zone Ай бұрын
@@ogunniransiji2686 great
@logeshc5432 Ай бұрын
Thanks bro
@suriyas_zone Ай бұрын
@@logeshc5432 ❤️
@tomshri1453 Ай бұрын
Audio is ok for now...but good with headpones..
@suriyas_zone Ай бұрын
@@tomshri1453 noted
@tomshri1453 Ай бұрын
🎉
@sakshinaik05 Ай бұрын
tysm for bringing this challenge
@suriyas_zone Ай бұрын
You're welcome..keep practicing and keep growing 😊
@mohammedvahid5099 Ай бұрын
In this playlist 7 videos r not displaying why bro. .. Eager to waiting 50days challenge ❤❤
@suriyas_zone Ай бұрын
Hi Mohammed, Today expect the video by 9:30 am and from tmrw the video will be released by 7:30 pm. Thank you for motivating !!
@mohammedvahid5099 Ай бұрын
Nice bro
@suriyas_zone Ай бұрын
Thank you bro
@vaibhavverma1340 Ай бұрын
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<=2
@suriyas_zone Ай бұрын
Great
@professor_DJ_010 Ай бұрын
Pls continue query interview questions along with this... U hv started difference questions.. But u stopped the problem solving questions... Please keep that series.. Continue that series
@suriyas_zone Ай бұрын
Yeah sure...just given the basics so that people can understand how the code is working ! From coming Sunday for the next 50 days we're going to solve the problems only..I'm not only going to solve it will explain the concept behind it on how we have to approach the data. Thank you for your valuable comment ! Will take into consideration
@AnkurRanjan Ай бұрын
good explanation
@suriyas_zone Ай бұрын
Thank you
@suriyas_zone Ай бұрын
Hi Guys, Please use headphones for better quality. Apologizes!
@tomshri1453 Ай бұрын
🎉
@suriyas_zone Ай бұрын
Thank you
@tomshri1453 Ай бұрын
🌾❤
@suriyas_zone Ай бұрын
Thank you
@sauravgoyal19 Ай бұрын
I made use of Cross Join WITH cte1 AS ( SELECT t1.TeamNames AS 'Team 1', t2.TeamNames AS 'Team 2' FROM teams t1 CROSS JOIN teams t2 WHERE t1.TeamNames < t2.TeamNames ) SELECT * FROM cte1 order by 1;
@nishantchavan2980 Ай бұрын
Great effort. Keep it up
@suriyas_zone Ай бұрын
Thank you Nishant ☺️ Please share
@vijayakumark6875 Ай бұрын
Not audible bro
@suriyas_zone Ай бұрын
Use headphones please and increase the volume bro. Sorry for the inconvenience. Will rectify in the upcoming video
@tomshri1453 Ай бұрын
yes bro
@suriyas_zone Ай бұрын
Hi Guys, There is some issue in the recorder. Please use headphones and increase the volume as much as you can. Apologies for it. Will rectify in the next video.
@maheshnagisetty4485 Ай бұрын
select category,subcategory from ( select *,rank() over(partition by category order by cast(price as money) desc) as rn from category ) as a where rn<=2 or price>50
@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!
@sunilrao6090 2 ай бұрын
Keep doing the good work sir
@suriyas_zone Ай бұрын
Sure Sunil. Thank you 😊
@piyushramkar9404 2 ай бұрын
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 2 ай бұрын
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 ?
@alagandulasandeep9148 2 ай бұрын
suer keep doing bro
@suriyas_zone 2 ай бұрын
Sure. Please do share
@suriyas6338 2 ай бұрын
Hi Guys, Due to some reason, i have done some editing on inshot as my premiere pro is having some issues. If there are any issues in recording please do let me know ! Thanks.
@logeshc5432 2 ай бұрын
No issues with the recording. The video is awesome and of high quality. Great job!
@deepakchawde4180 2 ай бұрын
Amazing sir Thanks for sharing ❤
@suriyas_zone 2 ай бұрын
Thank you. Please do share and subscribe 🎉
@logeshc5432 2 ай бұрын
well explained 🎉
@DevarajS-dp6xd 2 ай бұрын
🔥🔥🔥🔥🔥
@suriyas_zone 2 ай бұрын
Thank you bro 😊
@fahadbawazir562 2 ай бұрын
Please make full SQL video
@suriyas_zone 2 ай бұрын
Sure.soon
@user-mj6tj1gl9k 2 ай бұрын
Hi i am purchase head mnager in ibs hospital i want to change my filed in data science plss make data engineer playlist for data engineer for thies who want to nake transition pls
@suriyas_zone 2 ай бұрын
Sure. For any data role, sql is more important and based on analyst/engineer/scientists stack may change. Will plan a video soon !
@logeshc5432 2 ай бұрын
Wait for 2nd part..
@suriyas_zone 2 ай бұрын
Sure
@gandlaramu4511 2 ай бұрын
Good explanation bro, keep going ❤
@suriyas_zone 2 ай бұрын
Thanks bro 😊
@alagandulasandeep9148 3 ай бұрын
Super 😊😊
@suriyas_zone 3 ай бұрын
Thank you
@user-iv5kn5ld1v 3 ай бұрын
please make video on cte,view,store procedure,regexp,subquery
@suriyas_zone 3 ай бұрын
Soon ! Please share ! Thank you
@user-iv5kn5ld1v 3 ай бұрын
very nice sir...please make video on SQL and phython on real word problem also guided project please
@suriyas_zone 3 ай бұрын
Sure ❤️Thank you
@logeshc5432 3 ай бұрын
Super, well explained ❤
@suriyas_zone 3 ай бұрын
Thank you ☺️