how to use group by having

stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.

MIT License

9.72k stars 1.57k forks source link

how to use group by having #1222

Open kmitj opened 1 year ago

kmitj commented 1 year ago

"SELECT * as message_table FROM message_table WHERE message_table.type == "call") GROUP BY message_table.channelId HAVING max(message_table.messageId)"

how to build this query with filter and group functions?