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!

Register Log in
  • Congratulations Mike Lewis 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

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.

Similar threads

spd800c
  • Locked
  • Question
GIF icons not showing at runtime in Developer 10g
Replies
0
Views
130
spd800c
spd800c
onwagena
  • Locked
  • Question
Select top n rows for each value 1
Replies
4
Views
99
onwagena
onwagena
puma51
  • Locked
  • Question
SELECT RETURNING MULTIPLE ROWS
Replies
1
Views
93
lewisp
lewisp
meridian99
  • Locked
  • Question
Stepping thru rows
Replies
1
Views
63
BJCooperIT
BJCooperIT
mrfritz44
  • Locked
  • Question
"SELECT TOP" in Oracle SQL
Replies
4
Views
89
nagornyi
nagornyi

Part and Inventory Search

Sponsor

Back
Top