I have a data table of employees, I want to get how many same name employees in the database. Name information is saved as first\_name and last\_name. I have tried.

```
Select count(concat(first_name,'',last_name) as empname, (concat(first_name,'',last_name) as empname from xyz.

```

getting error.