Problem in group by syntax

Aktham Mahmoud

6y1.1k.NET

Greeating all

I've problem with group by syntax in SQL Visualstudio

I've been trying many solutions but no way..

How to resolve that?

SQL Synatx:

SELECT TOP (10) O_Id, OrderCode, DateOfOrder, Product_Name, SNO, Br_CodeID
FROM Orders
WHERE (OrderCode = OrderCode)
ORDER BY DateOfOrder DESC
GROUP BY OrderCode

See photo below:

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aktham Mahmoud6y ago
Greeting all

Thanks for everyone who trying to help me.

(Jenith Thakkar
Sai Kumar Koona

Rajanikant Hawaldar

Jignesh Kumar)

Actually am still trying until this moment to resolve this problem>

Sorry if am to explain my problem correctly

Problem description:

If cuteomer add to his online shopping basket many item as example (4 items) and continou his oreder submit, everyting going very well no problem with that.

A problem, when an admin bunch select (check new orders) as example, it show as this photo below:

So am tring in many ways to show three records depends as example in one record, and when an admin click on details buton move to (orderdetilas.aspx) as example.

nothing going well.
Jenith Thakkar6y ago
Here you need to apply two changes
1) keep the sequence properly 1. Group By 2. Order By.
2) Without using the aggregate function you need to use all columns which using in select statement in a group by
Sai Kumar Koona6y ago
Your query not following group by rules. Can you please cross verify with follow? GROUP BY clause is used with the SELECT statement. In the query, GROUP BY clause is placed after the WHERE clause. In the query, GROUP BY clause is placed before ORDER BY clause if used any.
Rajanikant Hawaldar6y ago
SELECT TOP (10) O_Id, OrderCode, DateOfOrder, Product_Name, SNO, Br_CodeID FROM Orders WHERE (OrderCode = OrderCode) GROUP BY OrderCode ORDER BY DateOfOrder DESC
Jignesh Kumar6y ago
Hi,

Goupr By always comes first and then Order by,

Please check below link,
https://stackoverflow.com/questions/18828590/use-group-by-and-order-by-at-same-time

Problem in group by syntax

Sai Kumar Koona