0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

select 
postid, count(1)
from 
  comments c 
where 
  c.creationdate = (
    select 
      max(c2.creationdate) 
    from 
      comments c2 
    where 
      c2.postid = c.postid
  )
  group by postid
  having count(1) > 1

view current version

edited dec 4

created dec 4 Janis123