SQL - count (*)

Question

Hello,

Here is my sql query:

select last_name, first_name
count (*)
from actor
group by last_name,
first_name
order by 3 desc

When running it I have an syntax error message around "count (*)":

LINE 2: count (*)
^
SQL state: 42601
Character: 37

Can you please help me? Thanks!

Answer 1

Hi, @Franck Nsungu Lukanda Welcome to Microsoft Q&A Thanks for posting your query.
Can you please try as below, comma is missing after first_name.

select last_name, first_name,
count (*)
from actor
group by last_name,
first_name
order by 3 desc

Regards
Geetha

Answer 2

Hi @GeethaThatipatri-MSFT , it works.
Thanks for the explanation!