Stack Exchange
log in help

Randomly select 5000 rows from Posts where post type is 1 i.e. questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT TOP 5000 *
FROM Posts 
WHERE PostTypeId=1
ORDER BY RAND();
fork query

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results