>Are you working with SQL Server?
>
>If yes, then
>

>;with cte as (select top (10) Event.Ro_No, Event.[DateTime] from Event ORDER BY Event.DateTime)
>
>select max(Event.DateTime) as LastDate, Event.Ro_No from cte

Hugo's solution resolves the issue.

That one was against a SQL Anywhere backend.