KPMG SQL Interview Question 2024 | Find out the Studentwise Total Marks for Top 2 Subjects

[@RaviSankar-ln3ki]

Informative.

[@skilltechath0n]

@RaviSankar-ln3ki Glad it was helpful!

[@apurvjadhav7995]

with cte as( select *,rank() over (partition by student_name order by marks desc) as rn from students) select student_name, sum(case when rn

[@skilltechath0n]

@apurvjadhav7995 Great! Keep learning :)

[@amitkumarkumarsinghpiyush323]

Bro aap output ki jagah questions likh diya kro jo new h unke liye direct output smjhna thoda tough h

[@skilltechath0n]

@amitkumarkumarsinghpiyush323 Sure. Will make a note of it. Thank you for the suggestion :)

[@ishanshubham8355]

select student_name, sum(marks) as marks from ( select *, dense_rank() over(partition by student_name order by marks desc) as rnk from students ) as m where rnk

[@skilltechath0n]

@ishanshubham8355 Continue practicing, Wish you all the success for your endeavours :)