title: How to use column alias define in select query in where clause
body: <p>Need to use the alias refrence, define  for column in where clause.</p>
  
  <pre><code>SELECT COUNT(S.ID)
       , SUBSTR(D.DEPARTENT_ID, 42,INSTR(D.DEPARTENT_ID, '.',2)-8) AS "**DEPT**"
    FROM STUDENT S, DEPARTMENT D
   WHERE S.OBJ LIKE '%' || **DEPT** || '%'
  </code></pre>