I have a table called BF Charging. I am trying to find the count of all duplicate records in this table.
SELECT YourColumn, COUNT(*) TotalCount
FROM BF Charging
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
I am receiving this error message
Msg 208, Level 16, State 1, Line 2
Invalid object name 'BF'.
Getting this because of the space in BF Charging. Tried using different parentheses but did not work.