java - 忽略 MS Access 中的特定列 SELECT DISTINCTROW

Question

我有一个 SQL 查询:

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

在Java中通过UCanAccess调用。

有没有什么办法，使用 SQL，将查询输出到结果集(我已经编码并工作)，其中删除具有重复标题和 ISBN(当 boolean 值为 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