select * from(
select row_number() over(partition by from_id,createtime order by nickname) as flag,* from(
SELECT
from_id,max(createtime) as createtime,isread as nickname
FROM
comments
WHERE
ctype=2015
AND to_id=2554
AND foreign_id=1
group by from_id,isread
order by from_id
)as tb1
)as tb2
where flag = 1
select row_number() over(partition by from_id,createtime order by nickname) as flag,* from(
SELECT
from_id,max(createtime) as createtime,isread as nickname
FROM
comments
WHERE
ctype=2015
AND to_id=2554
AND foreign_id=1
group by from_id,isread
order by from_id
)as tb1
)as tb2
where flag = 1