I need to develop a process to capture last record in the DB process where a quarry return multiple rows.
Select * from enp where join_Date > '10-02-2009'
it return 5 rows.
I wanted to capture last row from the result.
Please let me know any automatic process there in progress_SONIC_7.5.6
My SQL is a bit rusty but cant you change the sql to use an order by and the last() function? Then you would get what you need from the sql and don't need post-process it.
Reverse the order of the query and use TOP to limit the number of records returned.