忽略MS Access SELECT DISTINCTROW中的某一列

Question

我有一个SQL查询：

SELECT DISTINCTROW Title, Author, Genre, ISBN, UID, YearPurchased, Condition
from " + table + "
WHERE " + condition + " " + defOrder + ";

它是通过Java中的UCanAccess调用的。

有没有任何方法，使用SQL，将查询输出到ResultSet(我已经编码并正在工作(，在那里删除具有重复标题和ISBN的后续记录(当布尔值为true时((其他列名可能有重复(。

示例查询：

SELECT DISTINCTROW Title, Author, Genre, ISBN, UID, YearPurchased, Condition 
from tblBooks 
WHERE (Title LIKE 'spit*' OR Author LIKE 'spit*' OR Genre LIKE 'spit*') AND Loaned = No 
ORDER BY Title;

所需输出没有第二条记录：

https://prnt.sc/s67k2q

Answer 1

您可以使用聚合。我不确定你到底在定义哪一行，但这适用于你提供的数据：

SELECT Title, Author, Genre, ISBN, MIN(UID) as UID, YearPurchased, Condition
from " + table + "
WHERE " + condition + " " + defOrder + "
GROUP BY Title, Author, Genre, ISBN, YearPurchased, Condition