Received: from serv0.ilse.net (serv0.ilse.nl [194.158.182.236]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA15018 for ; Fri, 29 Oct 1999 10:33:02 -0400 (EDT) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv0.ilse.net (8.8.8/8.6.12) id QAA20160; Fri, 29 Oct 1999 16:32:53 +0200 (MET DST) Date: Fri, 29 Oct 1999 16:32:53 +0200 From: Mathijs Brands To: Frank Joerdens Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] trivial problem Message-ID: <19991029163253.A20151@ilse.nl> References: <19991029145529.A2258@flateric.x9media.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre4i In-Reply-To: <19991029145529.A2258@flateric.x9media.com>; from frank@x9media.com on Fri, Oct 29, 1999 at 02:55:29PM +0200 X-Unexpected-Header: The Spanish Inquisition On Fri, Oct 29, 1999 at 02:55:29PM +0200, Frank Joerdens allegedly wrote: > this sounds as if there must be a rather trivial solution: > > i am looking for the 50 rows with the largest value for a particular > column. i could create a view with > > create view as select * from table order by column; > > and then somehow only retrieve the top 50 rows . . . but how? > > thanks > > frank > > ************ Use limit? Mathijs