0

Please login or register to vote for this query.

(click on this box to dismiss)

List questions with top views

Perguntas e respostas para programadores profissionais e entusiastas

-- 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 ViewCount desc

fork query

created jul 21 11 jon.doe6372