Does anyone know what *rank() over(distribute by p_mfgr sort by p_name) *
does exactly and how it's different from *rank() over(partition by p_mfgr order by p_name)*? Thanks, Eric
Does anyone know what *rank() over(distribute by p_mfgr sort by p_name) *
does exactly and how it's different from *rank() over(partition by p_mfgr order by p_name)*? Thanks, Eric