0

Please login or register to vote for this query.

(click on this box to dismiss)

List questions with top views

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Top Views questions
-- List questions with top views
select top 200 Id as [Post Link], ViewCount, Score, CAST(CAST(ViewCount AS float)/Score AS DECIMAL(10,2)) [Voted by one in] from Posts
where ViewCount > 0 AND Score > 2 AND PostTypeId = 1
order by Score desc

fork query

edited jul 12 12 anonymous

created jul 21 11 jon.doe6372