0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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

fork query

edited sep 4 15 Yura Ivanov

created sep 4 15 anonymous