Pick random rows

Random_Rows.sql

/****** Script for slect random rwos. Works better with a large table and a good designed database ;)  ******/

declare @rand bigint
declare @maxid int = (select max(id) from dbo.TODOS);
select @rand = abs((CHECKSUM(newid()))) % @maxid;


select *
from TODOS as t
where t.id >= @rand
order by t.StartDate
offset 10 rows 
fetch next 5 rows only

-------------------------------------



	
DECLARE @row bigint=(
SELECT RAND(CHECKSUM(NEWID()))*SUM(rows) FROM sys.partitions
WHERE index_id IN (0, 1) AND [object_id]=OBJECT_ID('dbo.TODOS'));

SELECT *
FROM dbo.TODOS
ORDER BY (SELECT NULL)
OFFSET @row ROWS FETCH NEXT 5 ROWS ONLY;