Cacher is the code snippet organizer for pro developers

-- use NEWID() in conjunction with SELECT TOP to return random rows. Example below returns 5 random rows
SELECT TOP 5 ename, job
FROM emp
ORDER BY newID();