|
|
|
| SQL - Structured Query Language |
Query with OperatorBy default, logical operators are used to test for the truth of some condition that returns a Boolean data type with a value of TRUE, FALSE or UNKNOWN. Subquery can declare with logical operator that returns one or many record(s). The following subqueries are used to find out list of employees who have (not) working in the System Department. -- Example 52 --
USE EBusiness GO
SELECT Emp_Name FROM EMP WHERE Dept_Code IN (SELECT Dept_Code FROM DEPT WHERE Dept_Name = 'System')
SELECT Emp_Name FROM EMP WHERE Dept_Code NOT IN (SELECT Dept_Code FROM DEPT WHERE Dept_Name = 'System') Query Output Screen |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR