sql - 简单的 SQL 查询 : need this month data and previous month last 5 days data together

Question

需要同时查询本月数据和上月最近5天数据的SQL:

SELECT
  CONVERT(VARCHAR (10), wDate, 103) AS wDate,
  Empid,
  Process,
  Model,
  Qty,
  Section,
  Avlbl_Mins,
  NP_Mins,
  L_Mins,
  NP_Reason       AS NPReason,
  Process_Remarks AS PRem,
  Day_Remarks     AS DRem,
  Othermin,
  StdMin,
  Tstdmin,
  TAvlblmin
FROM tblProductionEffcyDetails
WHERE (DAY(EnteredDate) >= DAY(GETDATE()) - 5)
ORDER BY EnteredDate DESC

Answer 1

试试这个:获取上个月过去五天的数据

WHERE EnteredDate > (DATEADD(DAY,-5,DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))