Thank you for this video amigo! Is the WHERE a.team_no b.team_no really necessary? It seems like the following line with the < would be enough to ensure the row numbers are never equal.
Thanks for watching. The answer for your question is as per requirement one team should play with other team only once (IND-AUS but not AUS-IND). So thats why we need to use above condition. And Yes < can be also possible. You can check at your end also.
Second question query answer in mysql- SELECT result, ROW_NUMBER() OVER(ORDER BY result) as `groups` FROM(SELECT GROUP_CONCAT(id,name) as result FROM(SELECT *, ROW_NUMBER() OVER(PARTITION BY ID%2) as part FROM `group` ORDER BY name ASC) as e GROUP BY part ORDER BY part ASC) as e1
Awesome 👍
@@suhaschandras4318 Thanks for watching
Very helpful video
Thanks for watching
Great video sir. Thank You ❤
Thanks for watching
Nice explanation
Thanks for watching
🔥🔥🔥
Thanks for watching
Thank you for this video amigo! Is the WHERE a.team_no b.team_no really necessary? It seems like the following line with the < would be enough to ensure the row numbers are never equal.
Thanks for watching. The answer for your question is as per requirement one team should play with other team only once (IND-AUS but not AUS-IND). So thats why we need to use above condition. And Yes < can be also possible. You can check at your end also.
@@LearnwithPam-n5x I will try it out. Thank you for your response. Keep up the great work!
My small request could u please zoom in the query ur writing please because its so hard to seed
Yes sure, for next video I will zoom into screen. Thanks for watching.
bhai data bhi provide kr diya kro
Yes uploaded. Check in Description box. Thanks for watching.
Second question query answer in mysql-
SELECT result, ROW_NUMBER() OVER(ORDER BY result) as `groups` FROM(SELECT GROUP_CONCAT(id,name) as result FROM(SELECT *, ROW_NUMBER() OVER(PARTITION BY ID%2) as part FROM `group` ORDER BY name ASC) as e GROUP BY part ORDER BY part ASC) as e1
If you can explain in Hindi language will be more better...
Yes. I will try.
@@LearnwithPam-n5x thanks,
Your efforts are appreciatable
Beginner friendly...
Pam bro do u take private classes on query writing?? Also how do we know to use ntile and listtag ?? Please explain
No I don’t take private classes. But if you want I can create a separate video on that.