WikiGalaxy
SQL AND Operator
Introduction to SQL AND Operator
Understanding the SQL AND Operator
The SQL AND operator is used to filter records based on more than one condition. It returns records when all the conditions separated by AND are TRUE.
Basic Syntax
The basic syntax of the SQL AND operator is: SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ...;
Use Case Scenario
The AND operator is particularly useful when you need to filter data that meets multiple criteria, such as selecting employees who work in a specific department and earn above a certain salary.
SELECT * FROM Employees
WHERE Department = 'Sales'
AND Salary > 50000;
Advanced Usage
In complex queries, the AND operator can be combined with other logical operators like OR and NOT to create comprehensive filters.
Performance Considerations
Using multiple AND conditions can impact query performance, so it's essential to ensure that indexes support the search criteria.
Console Output:
John Doe | Sales | $60000
Jane Smith | Sales | $70000
Combining AND with Other Operators
AND with OR
The AND operator can be combined with the OR operator to form complex queries that require multiple conditions to be met.
Example Query
Selecting employees from either the Sales department or Marketing department who earn more than $50000:
SELECT * FROM Employees
WHERE (Department = 'Sales' OR Department = 'Marketing')
AND Salary > 50000;
AND with NOT
Using AND with NOT can exclude specific records while ensuring other conditions are met.
Console Output:
Anna Brown | Marketing | $55000
Practical Examples of AND Operator
Filtering Data
The AND operator is effective for filtering data based on specific criteria, such as finding products within a price range and in stock.
Example Query
Select products that are priced between $10 and $50 and are available in stock:
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 50
AND InStock = 1;
Combining Date Filters
Use the AND operator to filter records within a specific date range.
Console Output:
Product A | $20 | In Stock
Product B | $30 | In Stock
