I have employee audit table which has the multiple row of each employee. EX:Emp\_Table

```
Emp_id Manager_id Date
1         1       Sep'13
1         2       Sep'13  
1         3       Oct'13
2         1       Jan'13
2         1       Feb'13
3         1       Jan'13
3         1       Mar'13
3         2       Feb'13
3         2       Jan'13

```

Output I'm looking for the table is

> 
> Latest employee changes Rows
> 
> 
> 

According to the table above following output is required

```
  Emp_id  Manager_id   Date
    1         3       Oct'13  
    2         1       Feb'13
    3         1       Mar'13

```

I tried the below query

```
select emp_id,Manager_id,MAX(Date)
from Emp_Table
Group by emplid

```