SQLite查询以获取具有特定条件的记录

你需要数数 Manufacturer

select PART_NUMBER FROM Invoices GROUP BY "
     "PART_NUMBER HAVING count(MANUFACTURER)>1

你的数据看起来是这样的:

PART_NUMBER | MANUFACTURER
      1     |      A
      2     |      A
      2     |      A (duplicate entry)
      3     |      A
      3     |      B
      4     |      A
      4     |      B

HAVING COUNT(DISTINCT(MANUFACTURER))

在sqlite中,这看起来有点复杂:

SELECT COUNT(MANUFACTURER) FROM (SELECT DISTINCT MANUFACTURER FROM Table WHERE ...); 

this blog post .

setFilter(...)

这个问题看起来像是数据库设计问题。你知道吗 database normalization ?

当您规范化了表之后,问题就大大简化了。