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