More Related Content
Similar to SQL subqueries in database management system (20)
More from anjanasharma77573 (20)
Recently uploaded (20)
SQL subqueries in database management system
- 1. Subqueries Subqueries (also known as inner queries or nested queries) are a tool for performing operations in multiple steps.
- 2. •Display highest salary of employee. •Display employee name and department who's taking highest salary? •Display employee name and e_id who is taking second highest salary? •Write a query to display all the dept name along with no of employees working in that •Write a query to display all the dept name where no of employee is less then 2.
- 3. SQL IN Operator The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions. Example Return all customers from 'Germany', 'France', or 'UK‘ SELECT * FROM Customers WHERE Country IN ('Germany', 'France', 'UK'); HAVING Clause The HAVING clause was added to SQL because the WHERE keyword cannot be used with aggregate functions.
- 4. SQL Correlated Subqueries • It is sub query that use values from outer query • Top to down approach.
- 5. --Find all employes details who works in a department. --Find all employee details who do not work in a department. --Find the details of employees who are NOT WORKING IN HR DEPT. --Find the detail of emp who is Working on at least one project
- 6. SQL EXISTS Operator The EXISTS operator is used to test for the existence of any record in a sub query. The EXISTS operator returns TRUE if the sub query returns one or more records. SQL IN Operator The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions.