TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
qsc xcv
NA
2
2.5k
a table value unpivot and sum of those values
Mar 20 2013 1:37 AM
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
Reply
Answers (
0
)
insert Hindi using stored procedure only in MSSQL 2008 only
Have you ever forgot password of SQL Server