# Prisma, how to reverse order

> Learn how to reverse the order of results in Prisma by adding an orderBy clause to findMany and sorting by id in descending order to show the newest first.

Author: [Flavio Copes](https://flaviocopes.com/about/) | Published: 2021-07-15 | Topics: [Database](https://flaviocopes.com/tags/database/) | Canonical: https://flaviocopes.com/prisma-reverse-order/

I was getting data from the database using [Prisma](https://flaviocopes.com/prisma/).

In my specific case I was getting tweets from the `Tweets` table, and they were listed from oldest to newest. 

I wanted the opposite, like Twitter works - the newest shows up first.

So I picked my data fetching procedure:

```js
await prisma.tweet.findMany({})
```

and I added an `orderBy` attribute to order by `id` in descending order:

```js
await prisma.tweet.findMany({
  orderBy: [
    {
      id: 'desc'
    }
  ]
})
```