I've an sql table like this:

```
ID    NR    Status
1     510     2
2     510     2
3     510     2
.     ...     .
17    987     2
33    987     3
35    987     2

```

I want to get table that; 
If **NR** column has same values and **Status** column has different values. 
So, I want to get table that contains 17, 33 and 35 rows.

I try this but it does not work:

```
select * from table1 as t1
inner join table1 t2 ON t1.NR=t2.NR and t1.Status != t2.Status

```