Viewing 2 posts - 1 through 2 (of 2 total)
dnt know if this is what u want.
Select DataID, Title, Count(*) Over (Partition by DataID) as Result
FromProblem1
Order By DataID
the result is in this form
1Names2
2Books1
3Movies1
4Papers1
5Areas4
6Box1
January 21, 2009 at 2:56 pm
#930738
GREAT..its working fine now..
thanxx.
June 11, 2008 at 2:56 pm
#827546