I have a column A which is populated by application appending a unique number to the col value. Not all the records has the number. I need to get all the values of the changed column A(with numbers) to get the associated values of the column B in the result set. Table has 1 million rows.
Code:COL A Management group app Financial group app# 980543 Management group app# 567345 Financial group app