You are viewing a single comment's thread from:

RE: Offline

in #steemit7 years ago (edited)

这个sql语言会不会好些?

select a.* 

from TxComments a
inner join
(select permlink,
min(tx_id) as tx_id
from TxComments
where author = 'incrediblesnow' and title <> ''
group by permlink
) as b
on a.tx_id = b.tx_id and
a.permlink = b.permlink
order by a.tx_id desc

Sort:  

这个代码更加缜密一点