就是查詢當天8點到晚上8點的資料，按PN分組，要取當前分組的最后1條資料。
取出來是空的，白天是有資料的，晚上發出來的報表就是空的。
難道和下面這兩行代碼有關嗎？
time BETWEEN '08:00:00' and '19:59:59'
AND
Assemble_tab.date=convert(varchar(10),getdate(),120)
但是date里面是日期啊，沒有時間，時間是time欄位啊。
代碼如下：
SELECT
datetime as 日期,
time as 時間 ,
Project_name as 專案名稱,
[Date] as 日期,
class_type as 班別,
PN as 物料,
Standard_Production as 標準產能,
Actual_Capacity as 實際產能,
Undesirable_Reason_1 as 開關浮起,
Undesirable_Reason_2 as 其他不良,
Undesirable_Reason_3 as 雜質,
Undesirable_Reason_4 as 膠件臟污,
Undesirable_Reason_5 as 膠水臟污,
Undesirable_Reason_6 as 膠件損傷
FROM Assemble_tab
WHERE
pn!=0
AND
time BETWEEN '08:00:00' and '19:59:59'
AND
Assemble_tab.date=convert(varchar(10),getdate(),120)
and
time in (
SELECT
MAX(time) FROM Assemble_tab GROUP BY PN
)
資料庫圖如下
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/269022.html
標籤：基礎類
上一篇：sql問題，求解！！！！！！！
下一篇：如何在兩個表中實作資料抽取