Self Join in terdata?...

      SELECT e.emp_num, e.name, f.emp_num, f.name, e.country

     FROM employee AS e, employee AS f

     WHERE e.country = f.country

     AND   e.emp_num < f.emp_num

     ORDER BY e.emp_num, f.emp_num;


Referred : Teradata Document.

Comments

Popular posts from this blog

General information about Netezza : Default Error details

Minus in Teradata?...