title: How to display in Big Query ONLY duplicated records?
body: <p>To view records without duplicated ones, I use this SQL</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * EXCEPT(row_number)
  FROM (SELECT*,ROW_NUMBER() OVER (PARTITION BY orderid) row_number
  FROM `TABLE`)
  WHERE row_number = 1
  </code></pre>
  
  <p>What is the best practice to display only duplicated records from a single table? </p>