Select a random sample of results from a query result

by 
SELECT  *
FROM    (
        SELECT  *
        FROM    mytable
        ORDER BY
                dbms_random.value
        )
WHERE rownum <= 1000

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. SQL Query to concatenate column values from multiple rows in Oracle
  3. How to request a random row in SQL?
  4. Select First Row of Every Group in sql [duplicate]
  5. Paging with Oracle
  6. Comparing Dates in Oracle SQL
  7. Oracle Differences between NVL and Coalesce
  8. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  9. SQL – How to store and navigate hierarchies?
  10. GROUP BY / aggregate function confusion in SQL
  11. Oracle “(+)” Operator
  12. Calculating difference between two timestamps in Oracle in milliseconds
  13. How can I find which tables reference a given table in Oracle SQL Developer?
  14. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  15. How to check the maximum number of allowed connections to an Oracle database?
  16. Oracle equivalent of Postgres’ DISTINCT ON?
  17. Determine Oracle null == null
  18. How to anticipate and escape single quote ‘ in oracle
  19. Oracle insert if row does not exist
  20. SELECT INTO using Oracle
  21. `show create table` equivalent in oracle sql
  22. Query json dictionary data in SQL
  23. ORA-00972 identifier is too long alias column name
  24. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  25. How to insert a string which contains an “&”
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. Connecting to Oracle Database using Sql Server Integration Services
  28. Retrieve Oracle last inserted IDENTITY
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. Why are aggregate functions not allowed in where clause

Leave a Comment