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

Ask an Expert

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

Write your message here..

Related Questions

Declare keyword description in pl sql, DECLARE : This keyword signals t... 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 - bulk bind performance improvement, Using Host Arrays ... 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, Using a Host Variable You can declare the curso... 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- iterative control, Loop Labels Like the PL/SQL blocks, loop... 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 - syntax, SELECT INTO Statement   The SELECT INT... 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 in pl/sql, Declaring Objects: You can use the object ... 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, Using SET TRANSACTION You use the SET TRANSACTI... 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, Operators on Tables and Rows Row Extrac... 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 - parameter modes, IN OUT Mode An IN OUT parameter passes ... 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, Subprograms The PL/SQL has two types of subprograms known ... 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