0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

select
  p.OwnerUserId,
  p.Id,
  p.ViewCount,
  RANK() OVER (partition by p.OwnerUserId order by p.ViewCount desc, p.Id) as rank
from
  Posts p
where
  p.PostTypeId = 1
  and p.OwnerUserId is not null

view current version

edited dec 4

created dec 4 jon.doe44575