0

Please login or register to vote for this query.

(click on this box to dismiss)

Show all values in known tables that map a type id to a type name.

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

-- Show types
-- Show all values in known tables that map a type id to a type name.

--SELECT year(creationdate),count(*) from posts group by year(creationdate);




select q.id as QID, q.AcceptedAnswerId as QAnswerID, q.CreationDate as QCreationDate, q.score as QScore,
q.ViewCount as QViewCount, q.Body as Question, q.Tags, q.AnswerCount as QAnswerCount,q.FavoriteCount as QFavCount, q.ClosedDate as QClosedDate,
a.Body as Answer, a.CreationDate as ACreationDate, a.score as AScore, a.ViewCount as AViewCount, a.FavoriteCount as AFavCount
from posts q
join posts a on q.id = a.parentid and a.posttypeid=2
where q.posttypeid= 1
and q.creationdate between '01/01/2020 00:00:00' and '1/3/2020 23:59:59'

fork query

edited mar 28 23 anonymous

created jun 2 11 Gilles