Data Quality Management

To return duplicate Account/Contact/Lead names:

select name, count(id)

from <Account/Contact/Lead>

group by name

having count(id) > 1

To return null records

select name

from <Account/Contact/Lead>

where name = null

or

order by name ASC NULLS FIRST