NT
Size: a a a
NT
PE
ЮЛ
ЮЛ
А
ЮЛ
PE
ЮЛ
ЮЛ
А
ДМ
@Query(
"select * from message_table where (userId = :id or viaId = :id) and createdAt = (SELECT MAX(createdAt) FROM message_table where userId = :id or viaId = :id)")
ЮЛ
А
ЮЛ
ЮЛ
ЮЛ
ЮЛ
I
@Query(
"select * from message_table where (userId = :id or viaId = :id) and createdAt = (SELECT MAX(createdAt) FROM message_table where userId = :id or viaId = :id)")
select * from message_table where userId = :id or viaId = :id order by createdAt desc limit 1
NT