Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3A2f3885627 for ; Mon, 9 Apr 2001 22:41:03 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f3A2ev0a003656; Mon, 9 Apr 2001 20:40:57 -0600 Date: Mon, 9 Apr 2001 20:40:57 -0600 From: Roberto Mello To: wweng@pobox.com Cc: pgsql-sql@postgresql.org Subject: Re: Sorting and then... Message-ID: <20010409204057.A3626@cc.usu.edu> References: <9atfv4$gb0$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.15i In-Reply-To: <9atfv4$gb0$1@news.tht.net>; from wweng@kencast.com on Mon, Apr 09, 2001 at 07:22:52PM -0400 X-Archive-Number: 200104/130 X-Sequence-Number: 2477 On Mon, Apr 09, 2001 at 07:22:52PM -0400, Wei Weng wrote: > And I want to get the names of the largest 10 "id"s. How can I do that in > sql? What do you mean by "largest"? Largest id? "largest" text string? If it's the id you can do: select max(id) from ; -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Backup is for whimps!