Suppose you have a table named “Orders” with columns “OrderID”, “ProductID”, and “OrderDate”. Write an SQL query to find orders for the same product that were placed on the same day.
Loading
Identifying Missing Data
1 Answer
Select count(orderid) as Orders, productid, orderdate from orders
Group by productid, orderdate
Nandan HegdePosted Sep 16, 2023, 4:46 PM