Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
rrrrrrrrrrrryan
on Aug 24, 2022
|
parent
|
context
|
favorite
| on:
A Critique of SQL, 40 Years Later
To get 100k random rows in T-SQL it's:
SELECT TOP (100000) * FROM tblNm ORDER BY newid()
Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
SELECT TOP (100000) * FROM tblNm ORDER BY newid()