I've got a `SQLite` table which looks like this:

```
channel     message     time
123         hello       2014-03-25 21:33:52
123         there       2014-03-25 22:31:00
222         hi also     2014-01-22 10:19:00
222         bye         2014-01-22 11:29:00

```

Now I want to get the latest message for each `channel` and order all the results by `DESC`.

What I got so far is:

```
SELECT * from history WHERE GROUP BY channel order by date(time) DESC;

```

This returns the latest message for each `channel` but the results are not in order.

Im getting:

```
222         bye         2014-01-22 11:29:00
123         there       2014-03-25 22:31:00

```

Channel `123` should be on the top since its the newest one.

Any ideas what I'm doing wrong?