0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

select top 10
  p.OwnerUserId,
  coalesce(p.ViewCount, 0) as ViewCount
from
  Posts p
where
  p.PostTypeId = 1
  and p.OwnerUserId is not null
order by
  1,2

fork query

edited dec 4

created dec 4 anonymous