T-SQL – Differences Between SELECT COUNT() and SELECT COUNT(*)

sybaset-sql

I was looking at script in Sybase when I read something like 

    select count() from table;

the result it's exactly the same to

    select count(*) from table;

I'm curious, and I was looking out for more info in google but I didn't found anything.
I suppose that select count(*) from table it is ANSI and select count() from table not, and its just another way that sybase allow to do do it.

but anyway I would like to know if there is any difference or why are two different ways to do the same.

Best Answer

According to Sybase documentation:

COUNT(*) and COUNT() are semantically equivalent.
Related Question