I have the following **table**

```
col_1   col_2   col_3   col_4   

1       2       3       1

4       6       1       2

7       5       8       3

0       7       9       4

```

For example, In the above table, the value '1' in the first row(first column) is repeated in the second row(Third column). So I don't need the second row in my result. similarly I want to identify duplicate rows in my existing table and I must display only the rows as in my expected result below. How can I achieve this using t-sql?

Note: Col\_4 is the column which identifies each row uniquely. This column should not be included in the duplicate evaluation but should be used to remove duplicate rows as below(ascending order of col\_4).

**My Expected result:**

```
col_1   col_2   col_3  

1       2       3       

7       5       8

```