Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select top n rows

Status
Not open for further replies.

busi1

Technical User
Dec 14, 2005
56
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top