0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for finance professionals and academics

--SELECT MAX(ID) FROM PostsWithDeleted;
--SELECT MIN(ID) FROM PostsWithDeleted;

--SELECT * FROM PostsWithDeleted WHERE ID BETWEEN 79240666 AND 79240686;
SELECT * FROM PostsWithDeleted WHERE parentid = 4 and deletiondate is null;
--SELECT * FROM PostsWithDeleted WHERE id = 4;
--SELECT Score, CreationDate FROM POSTSWITHDELETED WHERE PARENTID = 4 AND PostTypeId = 2;

SELECT
  --q.*
  q.ID as [Post Link],
  a.Score
FROM PostsWithDeleted q
LEFT JOIN PostsWithDeleted a
ON q.ID = a.ParentId
WHERE 1=1
AND q.PostTypeId = 1  --q is a question
AND a.PostTypeId = 2  --a is an answer
AND q.ID < 100       --artificially limit ourselves for testing purposes
--AND q.ID > 79240000
GROUP BY q.ID, a.Score 
ORDER BY q.ID, a.Score DESC
OFFSET 1 ROW
FETCH NEXT 1 ROWS ONLY
;

view current version

edited dec 1

created nov 25 davidalayachew