0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

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

--SELECT * FROM PostsWithDeleted WHERE ID BETWEEN 79240666 AND 79240686;
SELECT * FROM PostsWithDeleted WHERE parentid <100 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        --artificially limit ourselves for testing purposes
  --AND q.ID > 79240000 
  ORDER BY q.ID, a.Score DESC
  OFFSET 1 ROW
  FETCH NEXT 1 ROWS ONLY
)
;
*/
SELECT *
FROM PostsWithDeleted q
WHERE CreationDate > '20241130'
;

fork query

edited dec 1 anonymous

created nov 25 davidalayachew