title: IF ELSE statement in Teradata
body: <p>I have two sql statements SQL 1 &amp; SQL 2. Further, I want to run them as per below logic,</p>
  
  <pre><code>SELECT * 
  FROM MY_TABLE
  WHERE COL1 &gt; 0;
  
  If ACTIVITY_COUNT = 0 THEN RUN SQL 1     ----- if records are present then run sql 1
  
  ELSE 
  
  RUN SQL 2    ----- if records are not present the run sql 2
  </code></pre>
  
  <p>Could you please suggest a TERADATA SQL CODE ?</p>
  
  <p>Thanks in Advance!</p>