SQL:列出星期一订购的产品

Question

我正在尝试查询星期一订购的产品，我对如何格式化或提取特定星期几到orderDate值感到困惑……

这是我有的..。(我对SQL相当陌生，所以我可能还不太熟悉。)

SELECT Products.productName, OrderDetails.orderNumber, Orders.orderDate

FROM Orders, OrderDetails, Products

WHERE Orders.orderDate LIKE '%Monday%; 

提前感谢！

Answer 1

SELECT  Products.productName , 
        OrderDetails.orderNumber , 
        DATENAME(dw,Orders.orderDate),  
        Orders.orderDate  
FROM Orders 
inner join OrderDetails  
   on OrderDetails.OrderID = Orders.ID 
inner join Products 
   on Products.ID = Orders.ProductID  
WHERE DATENAME(dw,Orders.orderDate) = 'Monday'

Answer 2

SELECT 
   Products.
   productName, 
   OrderDetails.orderNumber, 
   Orders.orderDate
FROM 
Orders 
JOIN OrderDetails ON Orders.OrdersID = OrderDetails.OrderID
JOIN Products ON OrderDetail.ProductID = Products.ProductID
WHERE 
DATENAME(DW,Orders.orderDate) = 'Monday'

Answer 3

使用Datepart函数，DATEPART(W，DATE)将返回星期几。(1作为星期一)

SELECT Products.productName, OrderDetails.orderNumber, Orders.orderDate

FROM Orders, OrderDetails, Products

WHERE DATEPART(w,Convert(Date,Orders.orderDate))=1

注释:这将给出笛卡尔乘积的结果。请确保正确地连接这些表