0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select
  qs.Id,
  qs.Title, 
  qs.Body, 
  qs.AcceptedAnswerId, 
  qs.CreationDate, 
  qs.Score, 
  qs.ViewCount, 
  qs.AnswerCount, 
  qs.ClosedDate, 
  qs.Tags,
  qs.FavoriteCount,
  (select CreationDate from Posts ps where ps.Id=qs.AcceptedAnswerId) as AnswerCreationDate
from Posts qs
where (qs.tags like '%<machine-learning>%' OR qs.tags like '%<machine-learning-model>%') 
      and qs.PostTypeId = 1

fork query

edited dec 12 19

created dec 12 19 anonymous