Professional Web Applications Themes

Oracle equivlent to Access 'select top 1...' ??? - Microsoft SQL / MS SQL Server

In MS Access I used to be able to issue a query like 'select top 1 field1, field2 from table1 where criteria1 order by DESC/ASC'.... That way I could so something like see the most recent x number of records (order by transaction_date DESC). I haven't been able to find a equivalent Oracle select statement that allows me to limit the number of returned records. Any help? Thanks, DJG *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Oracle equivlent to Access 'select top 1...' ???

    In MS Access I used to be able to issue a query like 'select top 1
    field1, field2 from table1 where criteria1 order by DESC/ASC'....

    That way I could so something like see the most recent x number of
    records (order by transaction_date DESC).

    I haven't been able to find a equivalent Oracle select statement that
    allows me to limit the number of returned records.

    Any help?

    Thanks, DJG



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Dave Guest

  2. #2

    Default Re: Oracle equivlent to Access 'select top 1...' ???

    I think you will have to use rownum to get that. there isn't any top clause
    available in Oracle.

    select * from
    (select * from table order by transaction_date DESC) a
    where rownum < 2

    --
    -Vishal

    "Dave Girard" <com> wrote in message
    news:phx.gbl... 


    Vishal Guest

  3. #3

    Default Re: Oracle equivlent to Access 'select top 1...' ???

    select field1, field2 from table1
    where criteria1
    and rownum = 1


    "Dave Girard" <com> wrote in message
    news:phx.gbl... 


    Alex Guest

Similar Threads

  1. (Oracle SQL) Select multiple columns from table
    By sinclairc5 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: November 30th, 03:23 AM
  2. Oracle Table Access With Oracle OLEDB Driver
    By FSchmitthammer in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 19th, 03:41 AM
  3. Replies: 0
    Last Post: December 16th, 06:19 PM
  4. Replies: 0
    Last Post: October 10th, 03:49 PM
  5. Replies: 2
    Last Post: July 9th, 07:01 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139