SQL - count (*)

Franck Nsungu Lukanda 86

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!

Accepted answer

GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee

2022-03-16T18:04:07.97+00:00

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
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee

2022-03-17T14:38:47.977+00:00

Thank you for visiting Microsoft QA forums! Have a great day!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Franck Nsungu Lukanda 86 Reputation points

2022-03-17T08:41:23.977+00:00

Hi @GeethaThatipatri-MSFT , it works.
Thanks for the explanation!
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee

2022-03-17T13:32:23.49+00:00

Hi, @Franck Nsungu Lukanda Good to hear that it worked for you.
If the above reply is useful. If yes, do click on 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee

2022-03-17T14:36:57.66+00:00

Thanks for your feedback @Franck Nsungu Lukanda could you please click on 'Mark as answer'

Regards
Geetha
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer