Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Houston
    Posts
    2

    Exclamation Unanswered: SQL equivalent of MS Access "FIRST()" function

    I need to know if there is an equivalent to the first() function that is used in MS Access.

  2. #2
    Join Date
    Sep 2003
    Location
    Lithuania
    Posts
    4

    Re: SQL equivalent of MS Access "FIRST()" function

    Originally posted by jbackhus
    I need to know if there is an equivalent to the first() function that is used in MS Access.
    Sorry, I am not very familiar with MS Access, but SQL has such thing:
    http://www.csis.gvsu.edu/GeneralInfo...5a.htm#1129681
    It's the FIRST() function.

  3. #3
    Join Date
    Sep 2003
    Location
    Colombo, Sri Lanka
    Posts
    63

    Re: SQL equivalent of MS Access "FIRST()" function

    standard SQL does not have this as I know. But there are certain delicts provided by dabase vendors to get the first one. This depends on the database you are using.

  4. #4
    Join Date
    Sep 2003
    Posts
    21

    Re: SQL equivalent of MS Access "FIRST()" function

    I have no knowledege on this topic. But I did find a thread on another forum.

    http://www.tek-tips.com/gviewthread....184/qid/646291

    You might also want to try using a either, TOP, MIN(), MAX(), and/or a combination of the functions.

  5. #5
    Join Date
    Sep 2003
    Location
    Colombo, Sri Lanka
    Posts
    63
    MIN() and MAX() are called aggrigate operations and it is intended to return the minimum value or the maximum value of a certain field, but not the first or the last. TOP is available to restrict the number of records selected from the query, say TOP 10 will only return the first 10 rows.

    Cheers,
    Suren.

Posting Permissions

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