Interesting properties of cross join - sql, PL-SQL Programming

Interesting properties of CROSS JOIN - SQL

Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOIN, CROSS JOIN is not idempotent. Let t be any table and let n be its cardinality. Then t CROSS JOIN t has twice as many columns as t and n2 rows. Also unlike JOIN, CROSS JOIN has no identity value. If t is a table, there is no table t0 such that t CROSS JOIN t0 = t. That's because t0 would be required to have no columns and exactly one row, but SQL doesn't recognize the existence of tables with no columns.

Posted Date: 1/18/2013 4:48:50 AM | Location : United States







Related Discussions:- Interesting properties of cross join - sql, Assignment Help, Ask Question on Interesting properties of cross join - sql, Get Answer, Expert's Help, Interesting properties of cross join - sql Discussions

Write discussion on Interesting properties of cross join - sql
Your posts are moderated
Related Questions
Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Rephrase Conditional Control Statements When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops evaluating the expression as s

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

Advantages of Wrapping   The PL/SQL Wrapper convert the PL/SQL source code into a transitional form of the object code. By hiding the application internals, the Wrapper secure

"Not Enforced" Table Constraints A constraint that is not enforced is not really a constraint within the meaning of the act, but SQL does have such a concept and it needs to b