title: Create a variable in Vertica
body: <p>I am transitioning from SQL Server to Vertica.  Is there any comparable way to create a variable?</p>
  
  <p>Usually I do something like:</p>
  
  <pre><code>Define @myVariable int
  Set @myVariable = select MAX(Field1) from myTable
  </code></pre>