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

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

Ending transactions, Ending Transactions A good quality programming pr... Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

An active database in pl-sql, Consider the following set of database tables... Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Bulk fetching - bulk bind performance improvement, Bulk Fetching The i... Bulk Fetching The illustration below shows that you can bulk-fetch from a cursor into one or more collections: DECLARE TYPE NameTab IS TABLE OF emp.ename%TYPE; TYPE S

Use tsql function sql server 2012, I want someone to write a TSQL function ... I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th

Overview of control structures-comparison operators, Overview of control st... Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Package body, The Package Body The package specification is implemented... The Package Body The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the p

Parameter and keyword description - loop statements, Parameter and Keyword ... Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

Entering and exiting - autonomous transaction, Entering and Exiting If... Entering and Exiting If you enter the executable part of an autonomous routine, the major transaction suspends. When you exit the routine, the major transaction resumes. To ex

Authorize and fetch data from instagram, Authorize and fetch data from Inst... Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author