Hello,

In Northwind database for orderdetails table:

SELECT orderid,productid,quantity as quantity FROM orderdetails GROUP BY productid ORDER BY productid,orderid

Why always give an error ?

SQL: group by clause missing or invalid

TIA