Semidifference via except and join - sql, PL-SQL Programming

Semidifference via EXCEPT and JOIN - SQL

SELECT *

FROM (SELECT StudentId

FROM IS_CALLED

WHERE Name = 'Devinder'

EXCEPT DISTINCT CORRESPONDING

SELECT StudentId

FROM IS_ENROLLED_ON

WHERE CourseId = 'C1') AS T1

NATURAL JOIN IS_CALLED

The NOT IN expression above appears to be testing for the appearance of a character string in a table, but in fact the first operand in this context is short for ROW(StudentId)

Posted Date: 1/18/2013 5:42:41 AM | Location : United States







Related Discussions:- Semidifference via except and join - sql, Assignment Help, Ask Question on Semidifference via except and join - sql, Get Answer, Expert's Help, Semidifference via except and join - sql Discussions

Write discussion on Semidifference via except and join - sql
Your posts are moderated
Related Questions
DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the

Using Host Arrays The Client-side programs can use anonymous PL/SQL blocks to bulk-bind input and output host arrays. However, this is the well-organized way to pass the colle

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax:

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

Using SET TRANSACTION You use the SET TRANSACTION statement to begin the read-only or read-write transaction, start an isolation level, or assign your present transaction to a

Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp