My table looks like this (and I'm using MySQL):

```
m_id | v_id | timestamp
------------------------
6    |   1  | 1333635317
34   |   1  | 1333635323
34   |   1  | 1333635336
6    |   1  | 1333635343
6    |   1  | 1333635349

```

My target is to take each m\_id one time, and order by the highest timestamp.

The result should be:

```
m_id | v_id | timestamp
------------------------
6    |   1  | 1333635349
34   |   1  | 1333635336

```

And i wrote this query:

```
SELECT * FROM table GROUP BY m_id ORDER BY timestamp DESC

```

But, the results are:

```
m_id | v_id | timestamp
------------------------
34   |   1  | 1333635323
6    |   1  | 1333635317

```

I think it causes because it first does GROUP\_BY and then ORDER the results.

Any ideas? Thank you.