Results 1 to 2 of 2

Thread: sample clause

  1. #1
    Join Date
    Jan 2004
    Posts
    83

    Unanswered: sample clause

    I know if I query
    SELECT *
    FROM myTable SAMPLE(10)

    It will return randomly 10% of the table. What if I want a specific number of rows? How do I do that?

  2. #2
    Join Date
    Jan 2004
    Posts
    83

    answer

    where rownum <= 4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •