1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT TOP(##num?500##)
  a.Id AS [Post Link], 
  a.OwnerUserId AS [User Link],
  a.OwnerDisplayName,
  a.Score, 
  q.OwnerUserId AS [User Link],
  q.OwnerDisplayName,
  DATEDIFF(month, q.CreationDate, a.CreationDate) AS Months,
  DATEDIFF(day, q.CreationDate, a.CreationDate) AS Days,
  DATEDIFF(hour, q.CreationDate, a.CreationDate) AS Hous,
  DATEDIFF(minute, q.CreationDate, a.CreationDate) AS Minutes
FROM Posts a INNER JOIN Posts q ON q.Id=a.ParentId
WHERE a.OwnerUserId<>q.OwnerUserId
ORDER BY Minutes

fork query

created aug 28 22 Martin20528