How do you define a correlated name?
A correlated name can be defined in the FROM clause of a query and in the first clause of an UPDATE or DELETE statement.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How do you define a constant? 06.11.08
Via define() directive, like define ("MYCONSTANT", 100);...What are the steps to build the datawarehouse 20.09.08
As far I know... Gathering bussiness requiremnts Identifying Sources Identifying Facts Defining Dimensions Define Attribues Redefine Dimensions & Attrib...What is a Style Sheet? 28.08.08
Style sheets are the way that standards-compliant Web designers define the layout, look-and-feel, and design of their pages. They are called Cascading Style She...What are the column name qualifiers ? 14.07.08
A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...How does the processing of a correlated subquery differ from a non correlated subquery ? 10.04.08
The subquery in a correlated subquery is reevaluated for every row of the table or view named in the outer query, while the subquery of a non correlated subqu...What is correlated subquery ? 10.04.08
A correlated subquery is one that has a correlation name as a table or view designator in the FROM clause of the outer query and the same correlation name as a...What are column-name qualifiers used ? 09.04.08
Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. C...What is an inner join, and an outer join ? 20.03.08
Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table w...What is a Style Sheet? 16.08.06
Style sheets are the way that standards-compliant Web designers define the layout, look-and-feel, and design of their pages. They are called Cascading Style She...What do you mean by Correlated subquery? 08.03.06
Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed...