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.
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
Post a Comment