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

Semidifference via NOT IN and a subquery

SELECT StudentId


WHERE Name = 'Devinder'

AND StudentId NOT IN (SELECT StudentId


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
Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

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

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

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

Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )