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
EXIT The EXIT statement forces a loop to done unconditionally. Whenever an EXIT statement is encountered, the loop is done immediately and controls the passes to the next statem

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Database Values You can use the SELECT statement to have the Oracle assign values to a variable. For Each and every item in the select list, there must be a matching, type-compa

Substitution and Instantiation - SQL It shows how NULL might appear in substitution for a parameter of a predicate and how it might thus participate in instantiation of that p

I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp