Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Select first 10 records of a file

    How do you compose an SQL statement so that only the first say 10 records are returned to your generic Select statement.

  2. #2
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50

    Re: Select first 10 records of a file

    SELECT TOP 10 * FROM ...

    Originally posted by harrisjah
    How do you compose an SQL statement so that only the first say 10 records are returned to your generic Select statement.

  3. #3
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Oracle,

    Select *
    from table
    where rownum <=10;
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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