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

Creating Views, Create a view named CustomerAddresses that shows the shippi... Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

Pl sql code review, PL SQL Code Review HEADER ELEMENTS File Name ... PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

Between and not between operator in sql, BETWEEN and NOT BETWEEN Operator i... BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

Different locking system in dbms, different lock modes used in the locking ... different lock modes used in the locking system

Updating objects in pl sql, Updating Objects: To change the attributes... Updating Objects: To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows: BEGIN UPDATE persons p SET p

Effect of anonymous columns, Effect of Anonymous Columns Now, recall t... Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

Mysql developer/programmer, Project Description: I want somebody who can... Project Description: I want somebody who can help me with an idea that I have been working on for a few months now. The person will require extensive knowledge of warcraft 3 PvP

Joining in sql, Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in... Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

%notfound - explicit cursor attributes, %NOTFOUND The %NOTFOUND is log... %NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

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.