You can simply select the same column twice with different aliases like this:

SELECT    client_code AS cl_code,   client_code AS acc_num FROM tb_accounts; 

This will return two columns, both populated with the values from client_code, but labeled differently as cl_code and acc_num.