select field with function

From: Pirola Davide (davide.pirol..tin.it)
Date: Fri Mar 03 2006 - 05:51:12 EST

  • Next message: Andrus Adamchik: "Re: select field with function"

    Hi,
    i have a little bit complex query:

    SELECT NAME, COUNT(*), sum(PRICE) FROM MYTABLE WHERE DATEDIFF('dd',CREATION_TIME, now()) < 10 GROUP BY NAME

    How i can configure this query in a datamap.xml file?

    I can use the "<qualifier>" tag for the WHERE part of the query... but for the GROUP BY and the SELECT field what i can use?


    Thank's
    Davide


    This archive was generated by hypermail 2.0.0 : Fri Mar 03 2006 - 05:51:14 EST