Using the EXISTS Operator in SQL: A Comprehensive Guide
☰Fullscreen
Table of Content:
The EXISTS operator is used to test for the existence of any record in a subquery.
The EXISTS operator returns true if the subquery returns one or more records.
Syntax:
<span class="pln"> SELECT column_name</span><span class="pun">(</span><span class="pln">s</span><span class="pun">)</span><span class="pln"> FROM table_name WHERE EXISTS </span><span class="pun">(</span><span class="pln">SELECT column_name FROM table_name WHERE condition</span><span class="pun">);</span><span class="pln"> </span>
|
EmpId |
EmpName |
EmpAddress |
EmpDept |
|
1 |
Rambo |
Kolkata |
IT |
|
2 |
Rohit |
Kolkata |
IT |
|
3 |
Rohon |
Kolkata |
ITIS |
|
4 |
Ronok |
Kolkata |
ITIS |
|
5 |
Rubin |
Kolkata |
ITIS |
|
6 |
Sorif |
Kolkata |
ADMIN |
|
7 |
Soriful |
Kolkata |
ADMIN |
|
8 |
Sofik |
Kolkata |
ADMIN |
Example:
Code:
<span class="pln"> SELECT </span><span class="typ">EmpName</span><span class="pun">,</span><span class="pln"> </span><span class="typ">EmpAddress</span><span class="pln"> FROM </span><span class="typ">Employee</span><span class="pln"> WHERE EXISTS </span><span class="pun">(</span><span class="pln">SELECT </span><span class="typ">EmpId</span><span class="pln"> FROM </span><span class="typ">Employee</span><span class="pln"> WHERE </span><span class="typ">EmpName</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">'Rambo'</span><span class="pun">)</span><span class="pln"> </span>
Output:
The above code will produce the following result-
|
EmpName |
EmpAddress |
|
Rambo |
Kolkata |
|
Rohit |
Kolkata |
|
Rohon |
Kolkata |
|
Ronok |
Kolkata |
|
Rubin |
Kolkata |
|
Sorif |
Kolkata |
|
Soriful |
Kolkata |
|
Sofik |
Kolkata |
No Questions Data Available.
No Program Data.