Select code, Max (LONGDESCRIPTION) from currency group by code
Get the following

But I'm set for external layer, select the following:
Select * from
(
Select code, Max (LONGDESCRIPTION) from currency group by code
) currency
Where 2='$';
So check error

CodePudding user response:

The great god help see, their top up