Database Management Systems Exp 5

23CS2014 - II Year - Artificial Intelligence and Machine Learning
Database Management Systems Lab-2025
Batch 5

Teachers:

Christina Nikitha 2950
School of COMPUTER SCIENCE AND TECHNOLOGY

Exp 5:Sub Query and Correlated Sub Query
To execute the given SQL queries to retrieve consolidated data by using sub-queries and correlated sub queries. A subquery is a query that's nested within another query. Subqueries can be used in the SELECT, WHERE, or HAVING clauses. They can return a single value or multiple rows or columns. Subqueries can be used to build complex statements from simpler ones. A correlated subquery is a subquery that uses values from the outer query in the inner query. Correlated subqueries are used when a subquery needs to return a different result for each row considered by the main query. For example, you can use a correlated subquery to find employees who earn more than their department's average salary.
KARUNYA INSTITUTE OF TECHNOLOGY AND SCIENCES

Видео Database Management Systems Exp 5 канала ASWANTH P URK24CS7127