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#Queries(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@...
>
https://lists.sourceforge.net/lists/listinfo/monetdb-users--
| Dr. Stefan Manegold | mailto:
Stefan.Manegold@... |
| 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 |
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/monetdb-users
