Is there a build in function in sql, to reverse the order in which the groupby works? I try to groupby a certain key but i would like to have the last inserted record returned and not the first inserted record.

Changing the order with orderby does not affect this behaviour.

Thanx in advance!

EDIT: 

this is the sample data:

```
id|value
-----
1 | A
2 | B
3 | B
4 | C

```

as return i want 

```
1 | A
3 | B
4 | C

```

not

```
1 | A
2 | B
4 | C

```

when using group by id don't get the result i want.