How you select Top n from Informix query SQL

[zishan619]

Hi:
I have a query which needs to select the last person who worked on an account. So my SQL query is
SELECT TOP 1 work_actions.RACF, work_actions.date_time_posted FROM work_actions
ORDER BY work_actions.date_time_posted DESC
It is giving me a syntax error?

 

[vpshriyan]

Hi,

Make use of FIRST keyword, and the modified SQL looks as below:

SELECT FIRST 1 racf, date_time_posted
FROM work_actions
ORDER BY date_time_posted DESC

Regards,
Shriyan

"The value of a program is proportional to the weight of its output."