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
12 months ago