How can I find only rows that match 2 columns among multiple columns with same values?

Hi,

How can I find rows that only match 2 columns among multiple columns with same values?
I need to find rows that have same values in 'layer' and 'left(distance)' columns and make another table consisting only these values.