Postgres Pro
Downloads
Home   >   mailing lists

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

From Shaozhong SHI
Subject How to select the last value/row?
Date
Msg-id CA+i5JwZj2iCWVok4Bh7E3Z1tWtXrU0ipyPZ0810gkPso7fKRuA@mail.gmail.com
Whole thread Raw
Responses Re: How to select the last value/row?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Working around insert into a_table from select things from a_function
Next
From: "David G. Johnston"
Date:
Subject: Re: How to select the last value/row?