Postgres Pro
Downloads
Home   >   mailing lists

Thread: last record selection

last record selection

From
"Stanislav A. Filippov"
Date:
Can anyone tell me if there is a direct way to SELECT the last record in
the table,
without selecting the whole table and retrieving all rows.

thanx

************

RE: [INTERFACES] last record selection

From
"Oscar Serrano"
Date:
----- Original Message ----- 
From: Stanislav A. Filippov <safilippov@ualr.edu>
To: <pgsql-interfaces@postgreSQL.org>
Sent: Tuesday, November 30, 1999 9:27 AM
Subject: [INTERFACES] last record selection


> Can anyone tell me if there is a direct way to SELECT the last record in
> the table,
> without selecting the whole table and retrieving all rows.

I don't know if this can be useful for you:

SELECT * FROM yourtable ORDER BY whatever LIMIT 1


> thanx
> 
> ************
> 


************

RE: [INTERFACES] last record selection

From
"Oscar Serrano"
Date:
----- Original Message ----- 
From: Stanislav A. Filippov <safilippov@ualr.edu>
To: <pgsql-interfaces@postgreSQL.org>
Sent: Tuesday, November 30, 1999 9:27 AM
Subject: [INTERFACES] last record selection


> Can anyone tell me if there is a direct way to SELECT the last record in
> the table,
> without selecting the whole table and retrieving all rows.

I don't know if this can be useful for you:

SELECT * FROM yourtable ORDER BY whatever LIMIT 1


> thanx
> 
> ************
> 


************