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
Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

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

Package Body: The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the pac

3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a

Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v