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

Enforce security in the database system, Question: (a) In the context o... Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Using cursor attributes - bulk bind performance improvement, Using Cursor A... Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Database values-assignments in pl/sql, Database Values You can use the S... 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

Fetching from a cursor variable, Fetching from a Cursor Variable The F... Fetching from a Cursor Variable The FETCH statement retrieve rows one at a time from the product set of a multi-row query. The syntax for the same is as shown: FETCH {curso

Update statement - syntax, UPDATE Statement   The UPDATE statement tra... UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

PROCEDURES AND FUNCTIONS QURIES, i NEED THE QURIES TO SOME OF THE PROBLEMS ... i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

Example of add constraint in sql, Example of ADD CONSTRAINT in SQL Exa... Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Advantages of pl/sql, Advantages of PL/SQL The PL/SQL is a high-perform... 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

Keyword and parameter description - if statement, Keyword and Parameter Des... Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

%rowcount, %ROWCOUNT When its cursor or cursor variable is opened, the... %ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche