Thanks for the playlist! I have watched all the videos till now! Kudos to your wonderful efforts! waiting for more videos :)
@ItJunction4all
Жыл бұрын
You are welcome! Good to hear that you have watched all videos ! Sure i will come up with more videos like this in coming days.
@sivasrimakurthi206
Жыл бұрын
@sunil - I particularly like the way, you break down the problem and logically solve the problem statement. It help me put my thoughts in methodical order. I hope, I learn something from your teachings.
@ItJunction4all
Жыл бұрын
Thank you Siva Srimakurthi ! I am glad that my videos are able to helping you so much.
@deepikameenakshisundaram1748
Жыл бұрын
I have odd issue, in my application one of procedure purpose will return data from previous record. This procedure never had any issues running on windows xp and sql 2000 server. But same procedure running on windows 10 and sql 2014 returns null character intermittently even though the previous record has valid data. Any suggestions how to identify the root for this issue? Tools,method, etc?
@ItJunction4all
Жыл бұрын
I may not be able to help you much on this issue. Probably you can try debugging step by step and see at which points that columns takes NULL value.
@dhyeypatel1335
Жыл бұрын
with cte as( select first_player as Player_id,first_score as score from Matches union all select second_player,second_score from Matches), cte2 as( select c.Player_id,sum(c.score) as score from cte c group by c.Player_id), cte3 as( select c2.Player_id as player_id,c2.score as score,p.group_id as group_, row_number() over(partition by p.group_id order by c2.player_id) as rank_ from cte2 c2 join Players p on c2.Player_id = p.player_id) select Player_id,score,group_ from cte3 where rank_ = 1
@learnforfree5270
Жыл бұрын
with cte as ( select *, (case when first_score>second_score then first_player when first_score=second_score and first_player
@ank_kumar12
11 ай бұрын
with tab1 as ( select t2.group_id,t2.player_id,t1.score, row_number() over(partition by t2.group_id order by t1.score desc, t2.player_id asc) as rnk from players t2 join (select t.first_player as players,sum(t.score) as score from ( select first_player,sum(first_score) as score from matches group by first_player union all select second_player,sum(second_score) from matches group by second_player ) t group by t.first_player ) t1 on t2.player_id = t1.players ) select player_id, group_id from tab1 where rnk =1;
Пікірлер: 9