Dear remi,
your question is a general SQL question and not a MonetDB specific. MonetDB
sql frontend follows the SQL standard so any SQL query that works in any
DBMS will work in the same way in MonetDB too.
If you have questions on how to formulate correct queries in SQL I would
advice you to use one of the many SQL references available in the web.
On the other hand, if you ran a correct SQL query against monetdb and you
got an error or incorrect results, meaning a possible bug, then please let
us know the error / output of MonetDB and we will help you.
lefteris
On Fri, Jun 28, 2013 at 4:05 PM, Rémi Daniel
Hello,
I'm a French user of MonetDB, and I have a SQL question, I want to execute on MonetDB equivalent of this mysql request, and i don't find any solution :
"SELECT field1, field2 FROM table GROUP BY field3 LIMIT 5;"
I want to do a GROUP BY of a field3 which is not in the SELECT to get a limit of request results by this field3, like the "first" function of some databases.
Does anyone have any idea on how I can do that ?
Thanks for your help,
Remi
--
Rémi Daniel Développeur Web rdaniel@inbox.fr
30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list