What does the SQL:2003 TABLESAMPLE clause provide?

SQL Fundamentals Hard

SQL Fundamentals — Hard

What does the SQL:2003 TABLESAMPLE clause provide?

Key points

  • TABLESAMPLE clause in SQL:2003 provides random sampling of table rows
  • SYSTEM and BERNOULLI are the two sampling methods available
  • Sampling is approximate, not exact
  • Avoids the need for a full table scan

Ready to go further?

Start full exam Practice more questions

Related questions