I believe something like below should work:

select Count(billing.first_name + billing.last_name) as combined,
billing.first_name + billing.last_name as name
from billing
group by billing.first_name + billing.last_name
having Count(billing.first_name + billing.last_name) > 1

Doug
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to