How to find duplication using select all and group by all
<p>I want to find duplication from a table, let's say users has columns name1, name2, ..., namen.</p>

<p>So to find duplicates in the table:</p>

<pre><code>select name1, name2, ...., namen
from users
group by name1, name2, ..., namen
having count(*) &gt; 1
</code></pre>

<p>But because n is too big, I don't want to write it all in select and group by.
Is there a way to shorten this like:</p>

<pre><code>select *
from users
group by *
having count(*) &gt; 1
</code></pre>

<p>Thanks.</p>