View previous topic :: View next topic
|
Author |
Message |
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
SELECT (MAX(VV_MRC_BASE_AMT) + MAX(VV_NRC_BASE_AMT))
FROM TAEVV.VV_CMPT_OVRD_RNG
WHERE VV_TRCK_ORDR_NUM = 8523
Out put is displaying 5 rows total of those two fields
12222
1700
23000
2700
10000
But i want to get the to total of all those 5 rows count.
IS it posible in this single query ? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might try:
SELECT SUM(MAX(VV_MRC_BASE_AMT) + MAX(VV_NRC_BASE_AMT)) etc. . . |
|
Back to top |
|
|
vijayprabu
New User
Joined: 15 Dec 2005 Posts: 21
|
|
|
|
dick scherrer wrote: |
Hello,
You might try:
SELECT SUM(MAX(VV_MRC_BASE_AMT) + MAX(VV_NRC_BASE_AMT)) etc. . . |
HI -
I am getting the Below error
,
, DSNT408I SQLCODE = -112, ERROR: THE OPERAND OF AN AGGREGATE FUNCTION
, INCLUDES AN AGGREGATE FUNCTION OR A SCALAR FULLSELECT
, DSNT418I SQLSTATE = 42607 SQLSTATE RETURN CODE
, DSNT415I SQLERRP = DSNXOOS1 SQL PROCEDURE DETECTING ERROR
, DSNT416I SQLERRD = -220 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
, DSNT416I SQLERRD = X'FFFFFF24' X'00000000' X'00000000'
, X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
, |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Looks like my bad
I'm not connected, so i didn't run a test. . .
Sorry for the mis-queue.
d |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi Vijayprabu
Try this query
Code: |
SELECT SUM(AMT) FROM (
(SELECT MAX(VV_MRC_BASE_AMT) AS AMT FROM TAEVV.VV_CMPT_OVRD_RNG WHERE VV_TRCK_ORDR_NUM = 8523
UNION ALL
SELECT MAX(VV_NRC_BASE_AMT) AS AMT FROM TAEVV.VV_CMPT_OVRD_RNG WHERE VV_TRCK_ORDR_NUM = 8523)
AS AMT; |
Hope this will help you
Regards
Raghu |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Alternatively ..
Code: |
SELECT A+B AS SUM FROM
(SELECT MAX(VV_MRC_BASE_AMT) AS A , MAX(VV_NRC_BASE_AMT) AS B
FROM TAEVV.VV_CMPT_OVRD_RNG WHERE VV_TRCK_ORDR_NUM = 8523 ) AS TEMP
|
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
I'm pretty sure that the output of the query is NOT 5 rows. |
|
Back to top |
|
|
|