Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Hamburg, Germany
    Posts
    14

    Question Unanswered: Access equivalent to Oracle's ROWNUM?

    Hi all,

    does anybody know an equivalent to Oracle's ROWNUM in Access? I need to retrieve the first 10 rows from a query...

    Thanks for your help,
    Ulf Moehring

  2. #2
    Join Date
    Jul 2003
    Posts
    48

    Re: Access equivalent to Oracle's ROWNUM?

    SELECT Top 10 * FROM TableName ORDER BY Field1 ASC

    Make sure you put an ORDER BY Clause on the correct field.

Posting Permissions

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