The following query will return a random sampling of data:
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (1 PERCENT);
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (100 PERCENT);
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (20 ROWS)
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (200 ROWS)
Not only will the records returned be random, but so will the number of rows.
No comments:
Post a Comment