0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

-- Longest time when an accepted answer is posted
-- Number of days between the question is asked and the accepted answer is posted.


select top 10 cast(a.creationdate - q.creationdate as float) as Days, q.id as [Post Link] from posts q
join posts a on a.id = q.acceptedanswerid
order by Days desc

fork query

created jan 22 anonymous