From Teresita.Castro@s-martmx.com Mon, 09 Jun 2003 18:36:05 -0700 From: "Teresita Castro" Date: Mon, 09 Jun 2003 18:36:05 -0700 Subject: How to put a TOP 1 in a select Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi!! I was working with SQL Server 2000, and now the company decided to change to Oracle. So I don't know much about Oracle, I am just reading a book and try to find information on the net. I am trying to do the next query, but I guess Oracle did not have the function TOP. How can I do a TOP 1 in Oracle?   select TOP 1 ITEM, TRANS_DATE from ICTRANS where   (COMPANY = 2000)  AND (TRANS_DATE BETWEEN  (CURRENT_DATE-14) AND CURRENT_DATE)    AND (DOC_TYPE = 'IS')  AND (REASON_CODE = 'VTCL')  AND (SUBSTR(ITEM, 2, 2) = '57') order by QUANTITY   I hope you undestand my English.