InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 22:56:48 GMT20http://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxThere is no sense the query you asked for, but it is possible to retrieve the info you need, justbuild 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, productBut 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 TotalFROM AOM_Tbl_PendingOrders Group By ClientName, OrderDateThe 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 Wed, 04 Aug 2010 02:36:13 GMTMarcos Leandro Rosahttp://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxIn 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).Sun, 25 Jul 2010 00:14:34 GMTamrata88http://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxHi,instead using all the columns in the group by clause, you can use aggregate function "OVER BY " in the query............ORgive me the details of the output what u want.....Sat, 24 Jul 2010 09:42:09 GMTVENUGOPAL.RRhttp://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxWhat every one else said, and also ...Why are you even trying to use a SUM ... when you're only looking at one row?Fri, 13 Feb 2009 13:00:03 GMTbvaljalo-1000038http://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxsuresh,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)Fri, 13 Feb 2009 11:48:55 GMTsam-770000http://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxThese error messages are pretty clear. Read the error messages then look at your query.Fri, 13 Feb 2009 11:25:37 GMTandrewd.smithhttp://www.sqlservercentral.com/Forums/Topic656860-338-1.aspxhere please refer the table:in that table value:1 is Order No ABCL is Client Name12/1/2009 12:00:00 AM is OrderDateARMIS - is Product1000 is Value1 is InvoiceQuantity1 is Pendingquantity 1 ABCL 12/1/2009 12:00:00 AM ARMIS 10000 1 11 HAL 12/1/2009 12:00:00 AM ARMIS 2000 2 21 NAL 12/1/2009 12:00:00 AM TimeCheck 20000 2 22 HidusthanLeaver 12/1/2009 12:00:00 AM ARMIS 2000 2 22 IOC 12/1/2009 12:00:00 AM TimeCheck 30000 2 23 BEML 12/1/2009 12:00:00 AM ARMIS 400000 2 23 ABCL 12/1/2009 12:00:00 AM TimeCheck 500000 3 3 I am using the following Groupby Queryselect OrderFormNo,ClientName,OrderDate,Product,sum(Value),InvoiceQuantity,PendingQuantity from AOM_Tbl_PendingOrders group by OrderFormNo, ClientName,OrderDateI have got the erreor belowMsg 8120, Level 16, State 1, Line 1Column 'AOM_Tbl_PendingOrders.Product' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.Msg 8120, Level 16, State 1, Line 1Column 'AOM_Tbl_PendingOrders.InvoiceQuantity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.Msg 8120, Level 16, State 1, Line 1Column 'AOM_Tbl_PendingOrders.PendingQuantity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.Can any one solve this issue.Fri, 13 Feb 2009 11:16:51 GMTsuresh.s-895438