hive row_number() over (partition by

Disturbed Dormouse answered on January 19, 2022 Popularity 3/10 Helpfulness 1/10

answer hive row_number() over (partition by

Comment

select roll_no,name,subject,marks,
ROW_NUMBER() OVER (PARTITION BY subject ORDER BY marks DESC) as rank
from students_report;

Popularity 3/10 Helpfulness 1/10 Language whatever

Tags: hive whatever

Link to this answer
Share Copy Link

Contributed on Jan 19 2022

Disturbed Dormouse

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.