Semidifference via not in and a subquery , PL-SQL Programming

Semidifference via NOT IN and a subquery

SELECT StudentId

FROM IS_CALLED

WHERE Name = 'Devinder'

AND StudentId NOT IN (SELECT StudentId

FROM IS_ENROLLED_ON

WHERE CourseId = 'C1')

In above Example < > ALL replaces NOT IN and in the absence of NULL has the same effect. It reads, somewhat ambiguously, as "not equal to all". In fact the expression yields TRUE if and only if the condition comparing StudentId values is TRUE for every row in the result of the subquery.

Posted Date: 1/18/2013 5:43:20 AM | Location : United States







Related Discussions:- Semidifference via not in and a subquery , Assignment Help, Ask Question on Semidifference via not in and a subquery , Get Answer, Expert's Help, Semidifference via not in and a subquery Discussions

Write discussion on Semidifference via not in and a subquery
Your posts are moderated
Related Questions
Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

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

Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

WHEN or THEN Key Constraints Suppose a table has two columns representing a period of time throughout which the information conveyed by the other columns is recorded as having

Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which