Beautifully explained !!!!!!!!!!! Keep doing great things. Its very easy to build logic, I can do it step by step. Really great
@TheMLMine
17 сағат бұрын
Thanks priyanka. Glad it was helpful
@ankitsrivastava6641
Ай бұрын
Thank you for the video. Keep taking on new question.
@TheMLMine
Ай бұрын
Thanks ankit. Glad it was helpful
@kirillnaumenko5806
Ай бұрын
Amazing explanation and delivery! Thank you for your work
@TheMLMine
Ай бұрын
Thanks. Glad it was helpful
@Pragya3421
2 ай бұрын
Keep making such sql interview question videos. Pls
@TheMLMine
2 ай бұрын
Sure, I already have part - 3 and part - 4 as well in this series. If you have any specific category of question that you want me to cover which is often asked in any interview, then let me know. I will make a separate video on that :)
@anandpathare6421
Ай бұрын
very good bro , nice and keep it go on
@TheMLMine
Ай бұрын
Thanks anand
@raviyadav-dt1tb
2 ай бұрын
its very helpful brother, but one more suggestion please also include more scenario in same case.
@TheMLMine
2 ай бұрын
Thanks for the feedback. Point noted
@sweetsubha514
3 ай бұрын
Well explained 👌👌.. Helpful
@TheMLMine
3 ай бұрын
Thanks subha
@ankitsinha5088
Ай бұрын
We can use dense rank as well or rank makes more sense. Can somebody explain?
@TheMLMine
Ай бұрын
Hi ankit, you are right. You can use dense_rank method as well. The only difference is if revenue of two products are same they will get the same rank value when using dense rank function while they will get different rank values when using simple rank function.
@sarashtirathi7587
2 ай бұрын
Perfectly 👌✅✅
@shubhamsoni174
Ай бұрын
Please try to bring more such videos 🙏
@TheMLMine
Ай бұрын
Sure shubham
@Mathew9010
2 ай бұрын
Brother make a video on TCS SQL interview questions for freshers 😊. I learned SQL in 4 days. But I should prepare interview questions 😅. I have interview on 5th July. And give me tips as I am a fresher 😊.
@TheMLMine
2 ай бұрын
Hello Mathew, good luck with your interview. However, I am sorry as I will not be able to make the video in this short period. But I have some tips for you - Tips: You can watch videos on TCS interview recordings conducted by TCS team itself (Link: kzitem.info/news/bejne/2qen1H-cpqVkg5w). Prepare both theory and practice questions. For theory you can refer to this video: kzitem.info/news/bejne/sIKr2YNskJacpKwsi=DcaIwO4PmWa0iJHy Hope you get through the interview. P.S. Never pretend if you don't know the answer, interviewers are smart enough to catch that. Be confident.
@TheMLMine
2 ай бұрын
And if you like, you can post your interview questions here and I will try to make a separate video on those. Thanks
@nishantgautam1581
Ай бұрын
bro i understand everything in sql , but when i start solving queries i take lot of time , i take lot of time to understand how shud i type it , any suggestion ?
@TheMLMine
Ай бұрын
Hi Nishant, it is normal in the beginning that it will take time to solve queries. That is why we need practice and practice. My suggestion would be to also understand the order of execution in which the commands are executed. It will help you understand the function of each commands and what happens in the backend (with order). You can refer this link, if it helps: sqlbolt.com/lesson/select_queries_order_of_execution And please practice questions without jumping at the solution and then understanding it backwards. Try to solve them by yourself first, be it wrong or right. Let me know if you need further help
Пікірлер: 24