Select Statement

jmss66 · May 27th, 2004, 01:55 PM

Can someone please help me with my SQL Statement. What I am trying to accomplish is to just get one record out of 10 in a recordset. I have the following SQL query but it is giving me an error message stating that from keyword is not found where expected. Somebody please help me figure it out.

select top 1 * from dbo.disburse_schedule where person_id = 12076 order by start_date DESC

Thanks,
Judy

Justin Cave · May 27th, 2004, 02:31 PM

Oracle does not support the TOP N syntax-- that's a SQL Server extension. Unless you have a "dbo" schema in your Oracle database with a disburse_schedule table, you don't want to qualify your Oracle table name with "dbo". You can do something like

Code:

SELECT *
  FROM (SELECT *
          FROM disburse_schedule
         WHERE person_id = 12076
         ORDER BY start_date DESC)
 WHERE rownum < 2

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC