0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

--SELECT Top 5 count(*)
SELECT Top 5000 *
FROM Posts p
WHERE p.Score>=3
AND p.CreationDate > '2000-02-01 00:00:00'
AND p.CreationDate < '2022-05-01 00:00:00'
AND p.Tags LIKE '%<java>%'
AND p.AnswerCount>0
ORDER BY NEWID()

fork query

edited jun 20 22

created jun 20 22 brucestayhungry