Postgres Pro
Downloads
Home   >   mailing lists

Re: How to select the last value/row? - Mailing list pgsql-sql

From David G. Johnston
Subject Re: How to select the last value/row?
Date
Msg-id CAKFQuwaS8FX+r3uBpjmS_6EcnOHKbi33thrOBQW_Zd9RLA6nOw@mail.gmail.com
Whole thread Raw
In response to How to select the last value/row?  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: How to select the last value/row?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
On Thu, Jul 6, 2023 at 8:47 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
Given,
ID
5
4
3
3
2
1


How to select the last one, to end up with

1

In Python, there are ways to handle ordered list.

In Postgres, is there something similar?

ORDER BY ASC so the "last item" appears first, then "LIMIT 1"

David J.

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: How to select the last value/row?
Next
From: Shaozhong SHI
Date:
Subject: Re: How to select the last value/row?