what is the difference between the %SELECT and %SELECTINIT meta sql functions.

%select : if any values have not selected then previous value will be there

%selectinit : if any values have not selected then previous value will reinitiate to null