Click here to Skip to main content
15,882,209 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
i want to get ID of all rows (in a single column) on which aggregate function is applied.

for example

select sum(colData), IDofAllRows from table1
Updated 23-Dec-15 12:19pm
CHill60 23-Dec-15 18:54pm    
Some sample data and your expected results would help us to help you. Use the "Improve question" link to add detail
jgakenhe 23-Dec-15 20:12pm    
So you want to aggregate results into 1 row. Oracle makes it easy, but SQL Server is not so easy. I am not sure what DBMS you're using, but the examples below should help.


SQL Server: No function I'm aware of, here's some technigues

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900