Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

selecting un-ordered rows


  • From: Dušan PEŠL <pesl(at)asprkyjov(dot)cz>
  • To: pgsql-novice(at)postgresql(dot)org
  • Subject: selecting un-ordered rows
  • Date: Tue, 16 May 2006 13:34:33 +0200
  • Message-id: <4469B8C9.3010808@asprkyjov.cz> <text/plain>

Hello,

have enyone idea, how to select all rows, preceeding 'mary'
(first two rows, but not LIMIT 2)

name     date
albert 2006-05-17 john 2006-05-17
mary     2006-05-17
benjamin 2006-05-17
carl     2006-05-17
alice    2006-05-17

thanks for help

Dan



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group