[MonetDB-users] limit the number of rows in the result set
Hi,
Could someone please tell me what the syntax is for selecting only say the top 20 rows ?
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
participants (2)
-
Roman Sokolyuk
-
Stefan Manegold