Hi,
In a table i have 3500 records with different employee toltals(ult_tot).I would like 500 contacts from the largest companies, one contact per company(there are duplicates). The ULT_TOT is the field to use for company size. Ideally I would like a split of payroll and IS/IT contacts (Primary_function field).
fields in the table are
member_id
company
primary_function
ult_tot
I am using oracle 10g
In a table i have 3500 records with different employee toltals(ult_tot).I would like 500 contacts from the largest companies, one contact per company(there are duplicates). The ULT_TOT is the field to use for company size. Ideally I would like a split of payroll and IS/IT contacts (Primary_function field).
fields in the table are
member_id
company
primary_function
ult_tot
I am using oracle 10g