SQL Presentation Overview

Objective

• Understanding the use and syntax of the IN keyword in SQL for efficiently handling multiple values within queries.

Importance of IN Keyword

• Used to specify multiple values in a WHERE condition.
• Equivalent to using multiple OR conditions, simplifying complex queries with many values.

Syntax

SELECT column1, column2, ..., columnN 
FROM table_name 
WHERE column_name IN (value1, value2, ..., valueN);

• SQL statements end with a semicolon.
• Example:

SELECT * FROM student WHERE city IN ('Sydney', 'Brisbane', 'Perth');

Benefits of Using IN

• Easier to specify multiple values in a list compared to using repeated OR conditions.
• Especially useful for scenarios with large value sets.

Examples

1. Specific Values Filtering

   SELECT * FROM employee WHERE city IN ('Ranchi', 'New Delhi', 'Bangalore');
   

   • Outputs rows where city is Ranchi, New Delhi, or Bangalore.

2. Negation with NOT

   SELECT * FROM employee WHERE city NOT IN ('Ranchi', 'New Delhi', 'Bangalore');
   

   • Filters cities excluding Ranchi, New Delhi, and Bangalore.

Nested Queries

• Concept: A query inside another query, used to dynamically determine the list of values.
• Example:

SELECT * FROM employee WHERE city IN (SELECT city FROM final);

• Retrieves rows from employee where the city matches any city from final.

Homework

• Analyze the query output for nested queries:

  SELECT * FROM employee WHERE city IN (SELECT city FROM final);
  

  • Check correctness of the depicted output and post answers in the comments.

Conclusion

• This presentation covered the efficient use of the IN keyword in SQL.
• Stay engaged and apply this knowledge to practical scenarios.

Thank you for watching!