Problem in group by syntax

Question

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:

Jenith Thakkar · Answer

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 Koona · Answer

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 Hawaldar · Answer

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 Kumar · Answer

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

Aktham Mahmoud · Answer

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.