Is there a function accepted in OTBI to print FIRST ROW of values?

Summary:

Summary:

I would like to Print all Invited Suppliers and selected Sites with site adress and site email but if Contact is blank in Negociation, only print first contact from the list of contacts in Supplier profile.

I used Copilot to optimize script and it added ROW_NUMBER() function to rank the contacts and then filter to keep only the first one which resulted in error in the Issue SQL;

It also tried MIN function that also resulted in error.

So is there a function accepted in OTBI to print FIRST ROW of values?


Content (please ensure you mask any confidential information):