Hacker News new | past | comments | ask | show | jobs | submit login

To get 100k random rows in T-SQL it's:

SELECT TOP (100000) * FROM tblNm ORDER BY newid()




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: