Re: [SQL] Limit rows

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Mark Jewiss <Mark(dot)Jewiss(at)knowledge(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Limit rows
Date: 1999-09-29 17:19:48
Message-ID: 199909291719.NAA03431@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Hello,
>
> I'm still thinking about ways to extract specific rows of data from a
> table, whilst ignoring others. i.e. I want to see rows 3-7 inclusive from
> a table.

SELECT * FROM table LIMIT 4 OFFSET 3

Should be in 6.5.*.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

  • Limit rows at 1999-09-29 15:17:03 from Mark Jewiss

Browse pgsql-sql by date

  From Date Subject
Next Message raptor 1999-09-29 18:56:55 Many questions
Previous Message Daniel Péder 1999-09-29 17:17:21 RE: [SQL] Limit rows