sql查询以选择两列中具有相同id但不同值的记录

sql查询以选择两列中具有相同id但不同值的记录

SELECt youtable.
FROM yourtable
WHERe articleid IN (SELECt articleid
FROM yourtable
WHERe (fieldsid, value) IN ((1,1),(2,1))
GROUP BY articleid
HAVINg COUNT(

)=2)

编辑：如果只需要第一条记录：

SELECt youtable.*FROM yourtableWHERe id IN (SELECt MIN(id)  FROM yourtable  WHERe (fieldsid, value) IN ((1,1),(2,1))  GROUP BY articleid  HAVINg COUNT(*)=2)