Sort:  

I have fixed the issue now. I am using

SELECT (parent_author + '/' +  parent_permlink), COUNT((parent_author + '/' +  parent_permlink)) FROM [dbo].[Comments] 
where author = 'steemladder' 
 AND created >= DATEADD(day,-1, GETDATE())
 GROUP BY (parent_author + '/' +  parent_permlink);

To track the number of comments on a post and I am getting only one comment. I will monitor it for couple more days.

Coin Marketplace

STEEM 0.21
TRX 0.25
JST 0.039
BTC 95882.33
ETH 3347.19
USDT 1.00
SBD 3.21