我有一個如下表：
ID Doc ID Names
XX 97... Name1
XY 97... Name 2
XZ 98... Name 1
...
現在我想查找特定名稱存在的所有重復項，但只有名稱中的任何重復項包含以 97 開頭的 Doc Id。SQL 的簡單重復查詢沒有幫助，請幫忙。
預期輸入和輸出
uj5u.com熱心網友回復：
考慮：
SELECT Table1.*, Query1.CountOfDocID
FROM (SELECT Names, Count(DocID) AS CountOfDocID FROM Table1 GROUP BY Names) AS Query1
INNER JOIN Table1 ON Query1.Names = Table1.Names
WHERE CountOfDocID>1 AND Table1.Names IN (SELECT Names FROM Table1 WHERE DocID LIKE "97*");
針對您的評論問題，將Allen Browne 網站的功能放入一個通用模塊中。在查詢或文本框中呼叫函式
SELECT DISTINCT Table1.Names, Query1.[CountOfDocID],
ConcatRelated("DocID","Table1","Names='" & [Table1]![Names] & "'") AS Docs
FROM (SELECT Names, Count(DocID) AS CountOfDocID FROM Table1 GROUP BY Names) AS Query1
INNER JOIN Table1 ON Query1.Names = Table1.Names
WHERE [CountOfDocID]>1 AND Table1.Names In (SELECT Names FROM Table1 WHERE DocID LIKE "97*");
uj5u.com熱心網友回復：
SELECT First(tblEmployee.[empid]) AS [tblEmployee.EmployeeID], Count([tblEmployee.empid]) AS NumberOfDups
FROM tblEmployee
GROUP BY tblEmployee.[empid]
HAVING (((Count(tblEmployee.[empid]))>1));
https://www.wikihow.com/Find-Duplicates-Easily-in-Microsoft-Access
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/505131.html
上一篇：MicrosoftAccess資料庫匯出到具有500萬行的excel/xml
下一篇：在SELECT查詢中設定列中的值