Thank you for your help
after using TopN the result was ok but is there a possibility to display this data in ascending order? I tried to change the sort order to ascending but the result was still in descending order
for the reports we are using peoplesoft queries. The query (
for example: select emplid, name, jobcode, effdt where emplid = '1111') can deliver a lot of rows with ascending effdt order for one employee. But for the report we need only the last three rows of the result set. As i know, it is not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.