0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

set statistics io on

/*
select P.Id as [Post Link], P.Body as [Parent text], C.Text as [Comment text]
from Posts as P join Comments as C on P.Id = C.PostId
where C.Score >= 5
order by P.Id
*/
/*
select P.Id, P.Title, P.CreationDate, C.CreationDate, datediff(d,P.CreationDate,C.CreationDate) as diff
from Posts as P join Comments as C on P.Id = C.PostId
where datediff(d,P.CreationDate,C.CreationDate) > 100
order by datediff(d,P.CreationDate,C.CreationDate) desc
*/

select * from Posts where Score > 30

fork query

edited dec 12 23

created dec 12 23 stevekass