On Fri, Nov 06, 2009 at 05:40:01PM -0500, Roman Sokolyuk wrote:

Hi,

Could someone please tell me what the syntax is for selecting only say the top 20 rows ?

e.g., select * from table limit 20; see also http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Queries.html#Querie... (section 3.1.7.2 Select lists, distinct, sorting, limit) and/or the SQL standard and/or your favourite SQL book or on-line tutorial. Stefan

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |