pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
last record selection 2+ messages / 2 participants [nested] [flat]
* last record selection @ 1999-11-30 08:27 Stanislav A. Filippov <safilippov@ualr.edu> 0 siblings, 1 reply; 2+ messages in thread From: Stanislav A. Filippov @ 1999-11-30 08:27 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: [INTERFACES] last record selection @ 1999-11-30 09:06 Oscar Serrano <oserra@fondos.net> parent: Stanislav A. Filippov <safilippov@ualr.edu> 0 siblings, 0 replies; 2+ messages in thread From: Oscar Serrano @ 1999-11-30 09:06 UTC (permalink / raw) To: pgsql-interfaces ----- 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 > > ************ > ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-11-30 09:06 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-11-30 08:27 last record selection Stanislav A. Filippov <safilippov@ualr.edu> 1999-11-30 09:06 ` Oscar Serrano <oserra@fondos.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox