Received: from tech.com.au (IDENT:root@techpt.lnk.telstra.net [139.130.75.122]) by hub.org (8.9.3/8.9.1) with ESMTP id KAA67546 for ; Thu, 22 Apr 1999 10:43:05 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from bigfoot.com (chris@localhost [127.0.0.1]) by tech.com.au (8.8.7/8.8.7) with ESMTP id AAA04224 for ; Fri, 23 Apr 1999 00:42:40 +1000 Sender: chris@tech.com.au Message-ID: <371F355F.7551BAAB@bigfoot.com> Date: Thu, 22 Apr 1999 14:42:39 +0000 From: Chris Bitmead X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Re: [SQL] SELECT TOP _x_ ?? References: <000401be8ccd$06c7e320$0a411a9f@cbn.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Justin Long wrote: > > In Microsoft SQL Server you could issue a command > > SELECT TOP 5 * FROM database... SELECT * FROM TABLE LIMIT 5; You may have to be running 6.5, not sure. -- Chris Bitmead http://www.bigfoot.com/~chris.bitmead mailto:chris.bitmead@bigfoot.com