Sqlite 错误包括任何人都可以帮助我的子句

Question

SELECT contactPhoneID, contactName, contactNumber, contactNumberType,
  contactEmail, contactImage, contactSortKey, contactCountryCode,
  contactRingTone, contactStatus, contactTimeStamp, contactMoodName,
  contactMoodType, contactEmotiUserFlag, contactSpeedDialID,
  contactSpeedDialFlag, contactFavorites, GROUP_CONCAT(contactNumber) AS contactNumber,
  contactName
FROM CONTACT_TABLE
WHERE contactFavorites = 'TRUE'
GROUP BY contactPhoneID

您好收到错误，在此旁边添加子句可以完美运行

Answer 1

若要使查询正常工作，需要按所有非聚合列进行 yo 分组：

SELECT contactPhoneID, contactName, contactNumber, contactNumberType,
  contactEmail, contactImage, contactSortKey, contactCountryCode,
  contactRingTone, contactStatus, contactTimeStamp, contactMoodName,
  contactMoodType, contactEmotiUserFlag, contactSpeedDialID,
  contactSpeedDialFlag, contactFavorites, GROUP_CONCAT(contactNumber) AS contactNumber,
  contactName
FROM CONTACT_TABLE
WHERE contactFavorites = 'TRUE'
GROUP BY contactPhoneID, contactName, contactNumber, contactNumberType,
  contactEmail, contactImage, contactSortKey, contactCountryCode,
  contactRingTone, contactStatus, contactTimeStamp, contactMoodName,
  contactMoodType, contactEmotiUserFlag, contactSpeedDialID,
  contactSpeedDialFlag, contactFavorites

MySQL支持非标准分组行为，如果您按少于所有非聚合列进行分组，它将为每个唯一组返回一行随机行。AFAIK，如果您尝试此操作，所有其他数据库都会引发语法异常。