Home » SQL & PL/SQL » SQL & PL/SQL » COUNT&ADD
COUNT&ADD [message #7780] Tue, 08 July 2003 12:54 Go to next message
IsDB
Messages: 1
Registered: July 2003
Junior Member
How do I add (e.g. amount due) attributes of multiple rows and display the product in a single tuple for multiple unique keys.

Should I use a derived colunm, please help.

Report message to a moderator

Re: COUNT&ADD [message #7781 is a reply to message #7780] Tue, 08 July 2003 13:08 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Sounds like a GROUP BY query to me...

select key, sum(amount)
  from t
 group by key;


If not, we'll need a more detailed question with examples.

Report message to a moderator

Previous Topic: Partitioned table script
Next Topic: Very Very Urgent abt UTL_FILE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 20:28:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.