Both query return the same output:
select COUNT(id) from Employee
select COUNT(All(id)) from Employee
So what is the difference in SQL-Server 2008R2?
There is no difference. ALL is the default keyword, as opposed to DISTINCT.
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
8 months ago