R4R Team working to provide free of cost for experienced and freshers

Tutorials | Examples|Interview Questions and Answers|Java Tutorials| C Tutorials | C++ Tutorials | Spring Tutorials| Hibernate Tutorials | JSP Tutorials | Servelets Tutorials| C# Tutorials | PHP Tutorials etc , Basics | Download Software | Data Types | Variables | Constant | Storage & Classes | Operators | Decisions Making | Loops | Functions| Numbers | Arrays | Pointers | String | Datastructure | Expressions | Preprocessor Statement | I/O | Exception Handling | OOPs Tutorial | Classes and object |C++ Inheritance Overloading | Polymorphism | Abstraction | Encapsulation | Interfaces | Multithreading etc

DATABASE & SQL/PLSQL

Sub queries with EXITS Clause
Previous Home Next

A sub query used with the EXISTS clause, always returns data in terms of a TRUE or FALSE value. It checks for the existence of a data rows according to the condition specified in the inner query and passes the existence status to the outer query to produce the result set.

Example:

SELECT  pub_name
FROM  publishers
WHERE  EXISTS (SELECT  *  FROM titles WHERE type='business')

output

Display the name of publishers who publish business related books.

SELECT title
FROM titles
WHERE advance > (SELECT  avg(advance)  FROM titlesWHERE type='business')

output

Display the titles of all those books for which the advance amount is greater than the average advance for bussiness related books.

Previous Home Next