Well good, then use what I wrote..
This is for Oracle.
SELECT *
FROM
(
SELECT ROWNUM rID, d.* FROM DOCUMENTS d
ORDER BY docid
) b
WHERE b.rID BETWEEN 2 AND 8
On Thu, 20 Jan 2005 08:26:19 -0400, daniel kessler <[EMAIL PROTECTED]> wrote:
> When I try to run this SQL, I receive the error
> FROM keyword not found where expected
> SELECT TOP 25 t1.* FROM (SELECT TOP 50
> service_population,agency,city,state,salary_status,int_agency_id FROM
> internships) t1
>
> If I remove the TOP 25 and TOP 50 it runs fine, but of course it doesn't do
> what I need once I remove them. I'm using Oracle and can't find Top in my
> reference, which isn't the best reference.
>
> >SELECT TOP 25 t1.*
> >FROM
> >(SELECT TOP 50
> >service_population,agency,city,state,salary_status,int_agency_id
> >FROM internships
> >#preservesinglequotes(find_text)#
> >ORDER BY agency DESC) t1
> >ORDER BY t1.agency ASC
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191174
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
