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

    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

    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