The table is like below:

```
employee, department, salary

Jack, 1, 400
Greg, 2, 350
John, 1, 450
Kate, 2, 420
Jane, 3, 300
Jessy, 2, 400
Kevin, 3, 380

```

I wish to do: Select the row that contains the highest salary of each department, I expect to return:

```
John,  1, 450
Jessy, 2, 400
Kevin, 3, 380

```

Here for department 1, John has the highest salary, so I select this whole row.

How to write this SQL?