HI SQL Friends
Can any one you help me please..
The below is the query
SELECT COUNT([dbo].[User].[Name]) FROM [dbo].[User]
WHERE [dbo].[User].[Name]='GaneshKumar' GROUP BY [dbo].[User].[Name] HAVING (COUNT([dbo].[User].[Name]) = 1)
In the above query the WHERE condition is satisfied then the result will be a integer value. If the codition is not satisfied the no row is returned.
My problem is, if now row is returned it should return 0 value,
Can any one help me please
Thanks
Ganesh Kumar V