No. It is not what I want.
This is a normal aggregation.
The sum function will be called once for each
group (SalespersonNm) and it will return one row.
What I have asked is : if I have 10 rows, can I return 12?
It's rude, but that's the idea.
Thanks,
Felix
DL Neil wrote:
Felix,
Is is it
Victor Pendleton wrote:
Felix,
Can you please give an example of what you are attempting to do?
-Original Message-
From: Felix LUNGU [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:22 AM
To: [EMAIL PROTECTED]
Subject: Aggregating function which returns more
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Felix LUNGU
Sent: Thursday, December 05, 2002 12:27 AM
To: Victor Pendleton; [EMAIL PROTECTED]
Subject: Re: Aggregating function which returns more than one row
The idea is simple:
I want to implement
Is is it possible to write an aggregation function which returns
more than one row?
Thanks,
felix
Mysql sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Felix,
Is is it possible to write an aggregation function which returns
more than one row?
Yes - if I have understood your requirement correctly.
It would have been helpful if you had given some idea of the
application/what you want to achieve. Here's an example from out of my
imagination: