Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:02:43
|
CJ writes ""I need to sort the results of the following query by the maximum net_sales (Top 100) by each Parent company and its subsidiaries.
SELECT parent_name, company_name, net_sales, revenue_date
FROM revenues
WHERE
revenue_date between ('7/31/1999') and ('8/1/2000')
ORDER BY parent_name, company_name, net_sales
COMPUTE SUM(net_sales) by parent_name, company_name"
|
|
|
|
|
|
TOP N SORT OF A COMPUTE CLAUSE