From: Stefan Paletta
Date: March 29 1999 2:33am
Subject: RE: select largest
List-Archive: http://lists.mysql.com/mysql/1114
Message-Id: <19990329023335.11010.qmail@horatio.lan.WRonline.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable


lorin@stripped wrote/schrieb/scribsit:
> I have a database with a column defined as:
> NOT NULL AUTO_INCREMENT
> Is there a simple SELECT statement to grab the 5 largest entries?
=20
select foocol from bartable order by foocol desc limit 5

Stefan