This Operator is used to check presence of data in Subquery .
If there are any records in Subquery ,
This operator will return “TRUE” otherwise It will return FALSE.
It can
be used with SELECT, DELETE,INSERT,UPDATE Statement.
Syntax :
SELECT COLUMN_NAME FROM TABLE_NAME WHERE EXISTS
(SELECT COLUMN_NAME FROM TABLE_NAME)
Example : There are created “Employee” and "Department" tables in a database
The following query will return DepartmentName of “Employee” for DepartmentId which exists in “Employee” Table.
SELECT NAME AS 'DEPARTMENT NAME' FROM DEPARTMENT D
WHERE EXISTS (SELECT NAME FROM EMPLOYEE E WHERE E.DEPARTMENTID=D.ID )
Output:
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.