From ebe124eacd7c3faa36ed358e7cc1d7c5b419e5f6 Mon Sep 17 00:00:00 2001
From: Daniel Baumann
+
The F.46. tsm_system_rows
F.46. tsm_system_rows
tsm_system_rows
module provides the table sampling method
SYSTEM_ROWS
, which can be used in
the TABLESAMPLE
clause of a SELECT
@@ -36,4 +36,4 @@ SELECT * FROM my_table TABLESAMPLE SYSTEM_ROWS(100);
This command will return a sample of 100 rows from the
table my_table
(unless the table does not have 100
visible rows, in which case all its rows are returned).
-