Testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

--select count(*) from (
SELECT question.creationdate Years,
--datepart(year,question.creationdate) Years, 
DATEDIFF(day, question.creationdate, asnswer.creationdate) ResponseInDays
--count(*) HowManyQuestion 
FROM posts question 
inner join posts asnswer 
on question.AcceptedAnswerId = asnswer.id
where question.creationdate BETWEEN '2009-10-01' AND '2009-10-31'--= 2009
and DATEDIFF(day, question.creationdate, asnswer.creationdate) >= 0
--group by datepart(year,question.creationdate)
--DATEDIFF(day, question.creationdate, asnswer.creationdate)
--order by datepart(year,question.creationdate)
--DATEDIFF(day, question.creationdate, asnswer.creationdate)
--desc
--)a

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results