What is a correlation name?

COBOL SQL Interview Questions

(Continued from previous question...)

What is a correlation name?

A correlation name is a special type of column designator that connects specific columns in the various levels of a multilevel SQL query.

(Continued on next question...)

Other Interview Questions

• In the WHERE clause what is BETWEEN and IN?
• What is an alias and how does it differ from a synonym?
• What do you accomplish by GROUP BY ... HAVING clause ?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• What is a synonym? How is it used
• Any SQL implementation covers data types in couple of main categories. Which of the following are those data types?
• What is meant by null?
• How do you eliminate duplicate values in SELECT?
• What is referential integrity?
• What is a synonym?
• More...