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

Reply via email to