0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

with cte as (
select
  p.OwnerUserId,
  max(coalesce(p.ViewCount, 0)) as max_views
from
  Posts p
where
  p.PostTypeId = 1
  and p.OwnerUserId is not null
group by
  p.OwnerUserId
)
select
  q.OwnerUserId,
  q.Id,
  q.ViewCount
from
  Posts q
inner join
  cte c
on
  q.OwnerUserId = c.OwnerUserId
  and q.ViewCount = c.max_views
order by
  1,3 desc

fork query

edited dec 4

created dec 4 anonymous