Module 2
Advanced MySQL Queries & Joins
20 mins read
Lesson 1: Subqueries & Joins
1.1 Subqueries in MySQL
Subqueries evaluate derived data using nested SELECT clauses within main WHERE conditions.
MYSQL
SELECT name, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);