[Home]  [Edit this page]  [Recent Changes]  [Special Pages]  [Help
SqlLimit

(SQL) limit

Limits the query to a certain number.

-- MySQL and PostGreSQL code
-- Show only the top row of a database
select * from DATABASE
limit 1


The command differs by environment
MySQL       limit 
PostGreSQL  limit
IBM DB2     fetch


Code links



last edited (November 16, 2006) by bilderbikkel, Number of views: 892, Current Rev: 2 (Diff)

[Edit this page]  [Page history]  [What links here]  [Discuss this topic]  [Printer Friendly]  

Members

Username:

Password:


Register
Forgot Password?




Programmers Heaven - for .NET, Java, C/C++ and WEB Developers!
© 1996-2008 Community Networks Ltd. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited. Violators of this policy may be subject to legal action. Please read Terms Of Use and Privacy Statement for more information. Development by Tore Nestenius at .NET Consultant - Synchron Data.