CoderZone.org

Category: >> Oracle PL/SQL >> SELECT with SAMPLE clause Bookmark and Share

<< lastnext >>

Snippet Name: SELECT with SAMPLE clause

Description: The sample clause can be used to return only a percentage of matching records in a query.

Also see:
» TABLE - Using Select Statement Wi...
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT / UNIQUE valu...
» SELECT: Get UNIQUE / DISTINCT valu...
» SELECT: Scalar Select
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT placement
» SELECT into a table
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT state...
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

SELECT * FROM <table_name> SAMPLE (percentage_of_rows);
 
-- create a sample set
CREATE TABLE test_set AS
SELECT object_name
FROM all_objects
WHERE SUBSTR(object_name,1,1) BETWEEN 'A' AND 'N';
 
-- see count of all records
SELECT COUNT(*)
FROM test_set;
 
- SELECT 20% OF records
SELECT COUNT(*) * 0.2
FROM test_set;
 
- SELECT 75% OF records
SELECT COUNT(*) * 0.75
FROM test_set;
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7