Tips and Traps¶

1. TABLESAMPLE must be immedidately after a table name.

2. The WHERE clause in the following SQL query runs after TABLESAMPLE.

    SELECT 
        *
    FROM 
        table_name 
    TABLESAMPLE (10 PERCENT) 
    WHERE 
        id = 1
   
   

   If you want to run a WHERE