Dear Friends,
My Name is Eduardo and this is my first post.
I want to make this query, I think It's possible. How I do proceed?
select
[dbo].[TestTable].Id,
[dbo].[TestTable].Name
(
select
Count(Sub.Id)
from
[dbo].[TestTable] As Sub
where
[dbo].[TestTable].Id = Sub.Id
) As 'Count'
from
[dbo].[TestTable]
Thanks !