Posted by Roy Harvey on 06/21/07 17:25

If you post a question to multiple groups is is best to put all the
group names on the same message so that all the discussions are tied
together.

See my reply in microsoft.public.sqlserver.programming

Roy Harvey
Beacon Falls, CT

On Thu, 21 Jun 2007 10:06:32 -0700, "webdevaccount@gmail.com"
<webdevaccount@gmail.com> wrote:

>Hello,
>
>Using SQL 2005. Columns:
>
>ID, int (PK, auto-increment by 1)
>WorkHours, int
>Name, varchar(100)
>
>I can't seem to get the following query to work. I want to return all
>Names and the sum of ALL work hours, in each row and order by each
>INDIVIDUAL work hour:
>
>SELECT Name, SUM(WorkHours) as h
>FROM Employers
>ORDER BY WorkHours DESC
>
>It seems that putting WorkHours in but the aggregate function and the
>ORDER BY clause creates a problem.
>
>Thank you for your help!

• Next in forum: Sum result of a Select
• Prev in forum: Re: Using the same column in bother SUM and ORDER BY? How?
• Thread view: Re: Using the same column in bother SUM and ORDER BY? How?

[Reply to this message]