List:General Discussion« Previous MessageNext Message »
From:Stefan Paletta Date:March 29 1999 2:33am
Subject:RE: select largest
View as plain text  
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?
 
select foocol from bartable order by foocol desc limit 5

Stefan

Thread
select largestlorin29 Mar
  • RE: select largestStefan Paletta29 Mar
    • Re: Help! Deciding on Java/C++ ?Joel Rees8 May
  • Re: select largestjkraai29 Mar
    • Re: Help! Deciding on Java/C++ ?Gelu7 May
    • Re: Help! Deciding on Java/C++ ?Mark Matthews7 May
    • Encrypted Way to connect to MysqlMarcel7 May
      • Re: Encrypted Way to connect to MysqlIgor Brynskich7 May
      • RE: Encrypted Way to connect to MysqlCal Evans8 May
  • Re: select largestSteve Edberg29 Mar
  • Re: Help! Deciding on Java/C++ ?Gelu7 May
  • Re: Help! Deciding on Java/C++ ?Mark Matthews7 May
  • Re: Help! Deciding on Java/C++ ?Gabriele Bartolini7 May
Re: select largestSteve Edberg29 Mar
RE: Help! Deciding on Java/C++ ?Paul Le7 May
Re: Help! Deciding on Java/C++ ?rup@bigpond.net.au8 May
Re: Help! Deciding on Java/C++ ?Gelu8 May
Re: Help! Deciding on Java/C++ ?Alec.Cawley8 May
Re: Help! Deciding on Java/C++ ?Mark Matthews8 May
Re: INDEXing on MERGED TABLESCharlie Thunderberg8 May
  • RE: INDEXing on MERGED TABLESJay Blanchard8 May
Re: Help! Deciding on Java/C++ ?Gelu8 May
Re: Help! Deciding on Java/C++ ?Frank Morton8 May