Received: from flateric.x9media.com ([62.104.116.67]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA99416 for ; Fri, 29 Oct 1999 08:54:37 -0400 (EDT) (envelope-from frank@x9media.com) Received: (from frank@localhost) by flateric.x9media.com (8.8.7/8.8.7) id OAA02265 for pgsql-sql@postgreSQL.org; Fri, 29 Oct 1999 14:55:30 +0200 Message-ID: <19991029145529.A2258@flateric.x9media.com> Date: Fri, 29 Oct 1999 14:55:29 +0200 From: Frank Joerdens To: pgsql-sql@postgreSQL.org Subject: trivial problem Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93.2 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