For List of Bank Branch and bank name, branch number & Swift Code

SELECT BANK_BRANCH_NAME, BANK_NAME, BRANCH_NUMBER , EFT_SWIFT_CODE FROM CE_BANK_BRANCHES_V
WHERE BANK_HOME_COUNTRY = 'GB' 
ORDER BY BANK_NAME, BANK_BRANCH_NAME

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin