A list of the top 10 industries that are enrolled with company

[report2000]

I would like to be able to query my industry table and see the ist of the top 10 (not first 10 records)industries that are enrolled with
my company

 

[SantaMufasa]

Report2000, that sounds like a righteous desire to me. It would help us help you if you could disclose specific tables, columns, and criteria by which you determine the "Top 10 Industries" enrolled with your company.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[report2000]

Here u go. this is the qury stucture. How can I group the industrycode so thwn i can pick up the top 10 industry

select
company.userid,
company.companyName,
Industry.industrycode,
indusrty.idustryName
from
company company
industry industry
where
company.indusrtycode = industry.industrycode

 

[Beilstwh]

You never gave the criterea for what is a top 10 company, but I will dummy up a test case.

select *
from
(select
company.userid,
company.companyName,
Industry.industrycode,
indusrty.idustryName
from
company company
industry industry
where
company.indusrtycode = industry.industrycode
order by company.ranking)
where rownum < 11;

Bill
Oracle DBA/Developer
New York State, USA

 

[johnherman]

Beilstwh has given you a good start, but how do you rank the top ten? Sales dollars? Sales quantities? Profitability?

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright