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 QuestionID, q.body as QuestionBody, 
a.id as AnswerID, a.body as AnswerBody 
from posts q
join posts a on q.id = a.parentid and a.posttypeid=2
where q.creationdate between '01/01/2020 00:00:00' and '1/3/2020 23:59:59' 
and q.posttypeid= 1

fork query

edited mar 28 anonymous

created jun 2 11 Gilles