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!

[@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 :)