*Sorry I forgot first to subscribe to the list. Sorry if you receive my request a second time. Hello, I would like to translate this SQL statement into XQuery. SELECT `dat`, AVG(dlay), SUM(dlay) FROM `wisc_berkeley` WHERE dat='20000801000000' AND `tick` < 100000 GROUP by dat; I tried this in this way, but yet I don’t know how to translate the group by. for $i in doc('wisc_berkeley.xml')/data/row where ($i/dat = '20000801000000' and $i/tick < 100000) return <ROW> { $i/dat } <sumDelay>{ sum($i/dlay) }</sumDelay> <avgDelay>{ avg($i/dlay) }</avgDelay> </ROW> Any comments please? HoumanReceived on Friday, 11 June 2004 16:19:19 UTC
This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 22:43:43 UTC