I have written the following query to pick up the address no. In case, there are multiple entries found in table ADRC according to my WHERE clause condition, the query returns the first address no out of those multiple address nos in one system 'A' whereas it returns the last address no. in similar situation in a different system B.
SELECT SINGLE addrnumber
WHERE sort2 EQ 'ABC'
AND addr_group EQ 'XY'.
Any idea why the same query is behaving differently in two system?