Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Answer
a table value unpivot and sum of those values
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
qsc xcv
11y
1k
1
Reply
i have a table socitymain .it's some row given here..........
here i display few row for example but really data is more than 1000 row...
--------------------------------------------------------------------
id
socityname
house
population
areaofsocity
1
abcd
10
150
10
2
cdf
5
15
20
3
zxc
20
20
10
4
bnmc
98
10
30
i want result the area's range wise socity count,population sum ,house sum
like......
values
0to10
11to20
21to30
31up
socity
2
1
1
house
30
5
98
population
170
15
10
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
insert Hindi using stored procedure only in MSSQL 2008 only
Have you ever forgot password of SQL Server