Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Count with diffrence

Author  Topic 

khalik
Constraint Violating Yak Guru

443 Posts

Posted - 2001-11-11 : 22:27:04
hi

i am working on a telecom project. i need to provide some reports. my table structure is like this

subscriber_Talkgroup: each subscriber has multi records.....
Subscriber_Ref
Talkgroup_Id

now i need to get the report like this

1 to 5 count
i.e. count of subscriber having counttalkgroup between 1 to 5

final report should look like this
1 - 5 10
5 - 10 1000
10 - 20 2355
20 - 50 9873
above 50 5472

any kind of help welcome


   

- Advertisement -