MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Thu, 6 Jul 2023 16:46:55 +0100
Message-ID: 
 <CA+i5JwZj2iCWVok4Bh7E3Z1tWtXrU0ipyPZ0810gkPso7fKRuA@mail.gmail.com>
Subject: How to select the last value/row?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ad358d05ffd36dd0"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwZj2iCWVok4Bh7E3Z1tWtXrU0ipyPZ0810gkPso7fKRuA%40mail.gmail.com>
Precedence: bulk

--000000000000ad358d05ffd36dd0
Content-Type: text/plain; charset="UTF-8"

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?


Regards,

David

--000000000000ad358d05ffd36dd0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Given,<div>ID</div><div>5</div><div>4</div><div>3</div><di=
v>3</div><div>2</div><div>1</div><div><br></div><div><br></div><div>How to =
select the last one, to end up with</div><div><br></div><div>1</div><div><b=
r></div><div>In Python, there are ways to handle ordered list.</div><div><b=
r></div><div>In Postgres, is there something similar?</div><div><br></div><=
div><br></div><div>Regards,</div><div><br></div><div>David</div></div>

--000000000000ad358d05ffd36dd0--