Wanted to select random rows from a table for some analysis. Found this.
SELECT * FROM TABLENAME
WHERE (ABS(CAST(
(BINARY_CHECKSUM
(COLUMNNAME, NEWID())) as int))
% 100) < 1
Monday, January 20, 2014
Select Random Rows from SQL Server DB Table
Wanted to select random rows from a table for some analysis. Found this.
SELECT * FROM TABLENAME
WHERE (ABS(CAST(
(BINARY_CHECKSUM
(COLUMNNAME, NEWID())) as int))
% 100) < 1
Subscribe to:
Posts (Atom)
Best Smartphones/tech of 2019
So I was looking for the best tech of 2019. Here it goes: New Pixel 3 XL Google - Pixel 3 XL with 64GB Memory Cell Phone (Unlocked) - ...
