If you know SQL questions that were asked in any job interview, do write them in comments. If popular, I will make a solution video on the same 😊

GOOD❤

This is the best explanation I have ever seen without complicating the thing. Even a beginner can understand the functions of '"LIMIT, OFFSET, DENSE_RNK, RNK" etc.

@TheMLMine

16 күн бұрын

Thank you Pragya

This is the most concise as well as detailed explanation to the question!! You deserve more likes and subs!!!! And trust me this my second time commenting of KZread ever!! Thought your explanation is crisp and clear!! Also Please cover topics like stored procedures, indexing, normalisation etc!! Would really appreciate!! Thank you!! Keep up the good work!!!

@TheMLMine

14 күн бұрын

Thank you. Glad to hear. Sure, I will try to cover these topics in a separate video.

Wonderful explanation 😊keep it up✌️

@TheMLMine

10 күн бұрын

Thanks apurva

So, in case of Dense_rank, we don't need to use the "distinct" command for repeated salary? Why so?

@TheMLMine

16 күн бұрын

Correct. You need to understand that when we used LIMIT with OFFSET. The duplicate salaries were counted as two separate instances while counting with OFFSET command. Ideally, the salary of Vinay and Prashant should be counted as one which is the 4th highest salary (not 4th and 5th highest salary). To avoid that we used DISTINCT, so that only unique salaries are provided to the OFFSET command (to overcome its above discussed limitation). While in DENSE_RANK we don't have such issue. It automatically provided the same rank to Vinay and Prashant, indicating that the two rows are counted as single instance (unlike OFFSET). So, we don't need to use DISTINCT command here. Hope it answers your question !

Wow the way you explained 👌..Thank you so much... very informative... And please make a video on MySQL index,stored procedure, views & remove duplicates and also joins (queries)

@TheMLMine

Ай бұрын

Thanks subha. I will try to cover that in future.

Great 👍🏻 but what abt pandas tutorial part-3 😢

@TheMLMine

Ай бұрын

Hi Rokith, are there any specific topics in the pandas tutorial that you think were important and were not covered? Let me know

I’m facing more challenges in sql how to overcome it? Please help me

@TheMLMine

10 күн бұрын

Hey Ravi, could you please explain what challenges you are facing in SQL?

@raviyadav-dt1tb

10 күн бұрын

@@TheMLMine thank you bro i mean to say I’m weak in sql query because in interviews most of the time I got rejected due to only sql query

@TheMLMine

9 күн бұрын

Even in my case as well, I got rejected a few times just because of SQL queries. What I did is - There are SQL questions that are asked in interviews and are standard. Try to solve all of them. Watch SQL interview questions from different KZread channels as well. It will increase the probability of solving questions in your next interview. - Don't just see the solution, but understand the approach. Ask questions like what would happen If I used this command instead of that and spend some time with the solution. It will develop your thinking pattern for solving new problems. - Trust your capabilities, you can crack the interview only if you believe that you can do it. Stick to it. I know you will get through it as well.