Get Zia to highlight duplicate rows

Get Zia to highlight duplicate rows

I'm trying to find the duplicate rows in a large table.  I could create a SQL query that counts when every field has the same value, but there are a lot of columns so that would be a slow job.  It seems an ideal task for AI as it is a task with defined parameters for data quality, but Zia could not understand my request.

Even better if it could deduplicate the table for me!