如何添加另一列到其他列的SELECT DISTINCT查询？

Question

我有这个表

CREATE TABLE APmeasure 
(id_APmeasure INTEGER PRIMARY KEY AUTOINCREMENT 
, RSSI TEXT, TimeOfMeasure DATETIME 
, BSSID TEXT, id_APm INTEGER NOT NULL 
, FOREIGN KEY (id_APm) REFERENCES APTable (id_Ap) ON DELETE CASCADE) 

我想打一个查询这会给我的TimeOfMeasure和BSSID不同的结果，这样的：

SELECT DISTINCT TimeOfMeasure, BSSID 
FROM APmeasure 
WHERE "condition" 

但是，这将取回我的其他列表，与DISTINCT查询相关。

我该怎么做？

Answer 1

1. 执行不同/分组操作，
2. 加入导致不同/分组操作的...

喜欢的东西：

SELECT [whichever columns you want] 
    FROM APmeasure 
     JOIN (
      SELECT TimeOfMeasure, BSSID 
      FROM APmeasure 
      WHERE [condition] 
     GROUP BY TimeOfMeasure, BSSID 
     ) x 
     ON x.TimeOfMeasure = APmeasure.TimeOfMeasure 
    AND x.BSSID = APmeasure.BSSID 
     [any other joins you need]