Group by Query Error

Question

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

andrewd.smith SSCrazy Eights Points: 8444 More actions · Answer 1

These error messages are pretty clear.

Read the error messages then look at your query.

sam-770000 Ten Centuries Points: 1267 More actions · Answer 2

suresh,

Try this: -

select OrderFormNo

,ClientName

,OrderDate

,Product

,sum(Value)

,InvoiceQuantity

,PendingQuantity

from AOM_Tbl_PendingOrders

group by OrderFormNo, ClientName,OrderDate,Product,InvoiceQuantity,PendingQuantity

In your case, remember that whenever you use the group by clause you need to add all the other colums as well except the function column (i.e. sum)

bvaljalo-1000038 Right there with Babe Points: 760 More actions · Answer 3

What every one else said, and also ...

Why are you even trying to use a SUM ... when you're only looking at one row?

VENUGOPAL.RR Ten Centuries Points: 1395 More actions · Answer 4

Hi,

instead using all the columns in the group by clause, you can use aggregate function "OVER BY " in the query............

OR

give me the details of the output what u want.....

amrata88 SSC Enthusiast Points: 196 More actions · Answer 5

In group by clause, you should include all the columns present in the select list that are not aggregated.

So, in this example include all the columns in the group by clause except Sum(Value).

Marcos Leandro Rosa Mr or Mrs. 500 Points: 512 More actions · Answer 6

There is no sense the query you asked for, but it is possible to retrieve the info you need, just

build your query like the below one:

SELECT OrderFormNo

,ClientName

,OrderDate

,Product

,sum(Value)as Total

,InvoiceQuantity

,PendingQuantity

FROM AOM_Tbl_PendingOrders

GROUP BY OrderFormNo, ClientName,OrderDate, InvoiceQuantity, PendingQuantity, product

But remember there is no sense you get all the fields to sum. You must build a result set with some sense for example:

SELECT ClientName, OrderDate, Sum(value) as Total

FROM AOM_Tbl_PendingOrders

Group By ClientName, OrderDate

The above query is gathering All Orders made in a time stamp from customers and applying a sum on value field.

It has sense because you can count and know how much you have gain in that time for each Customer.

I know it is an old post, but I resolved to explain a little bit more why it had no sense like some folks were talking!

Regards

Best Regards,
Marcos Rosa / marcosfac@gmail.com