SQL - Help with Analytic function

[hrishy]

Hi

You might want to try

select
HIER_LEVEL,  
STANDARD_SOURCE,
TITLE,	
YEAR_ADOPTED,
row_number() over(partition by TITLE,	
                                          YEAR_ADOPTED
                             order by title,year_adopted) group_id
from table