Most viewed questions


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

Вопросы и ответы для программистов

select top 100 
format(p.CreationDate, 'd','ru-ru'), 
  p.Score [Рейтинг], as [Post Link],
  ts.DisplayName [Топик-стартер],
  ts.Reputation [Репутация ТС], 
  p.ViewCount [Просмотров], 
  p.AnswerCount [Ответов],
  iif(p.AcceptedAnswerId is not NULL, 'x','') [Ответ принят],
  co.DisplayName [Автор принятого ответа],
  co.Reputation [Репутация ответившего]
from Posts p 
  join users ts on p.OwnerUserId =
  left join Posts a on p.AcceptedAnswerId =
  left join Users co on a.OwnerUserId =
where p.posttypeid = 1
order by p.ViewCount desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results