Rathrola Prem Kumar
Identifying Missing Data

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.

By Rathrola Prem Kumar in SQL on Aug 21 2023
  • Nandan Hegde
    Sep, 2023 16

    Select count(orderid) as Orders, productid, orderdate from orders Group by productid, orderdate

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS