SQL EXISTS

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL EXISTS - Introduction and syntax

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL EXISTS statement. Write SQL syntax for the SQL EXISTS statement along with an example.

SQL EXISTS: If the subquery returns at least one row the EXISTS condition is considered "to be met".

Syntax:
SELECT columns FROM tables WHERE EXISTS ( subquery );

Example:
SELECT * FROM employee WHERE EXISTS (select * from appraisal where employee.employee_id = appraisal.employee_id);

<<Previous  Next>>