title: Teradata - How can I extract all rows of a partition using the qualify statement?
body: <p>I have some data in a table that looks like the following</p>
  
  <pre><code>Username     Loaddate
  --------    ----------
  GITTES1     2016-01-25
  GITTES1     2016-01-25
  GITTES1     2016-01-25
  GITTES1     2016-01-24
  GITTES1     2016-01-23
  </code></pre>
  
  <p>Is there a way I can extract all the rows for GITTES1 with LOADDATE = 2016-01-25 using qualify statement. The number of rows in this partition can vary from 0 to n .. and there are multiple such users.</p>