Create view with multiple select statements in sql

A subquery is embedded inside another query and acts as input or output for that query.

Create view with multiple select statements in mysql

Create view with multiple select statements in mysql

What will be the output of mysql statement select avg(salary) from salary;?

Views and subqueries in sql

View vs subquery

Create view using subquery in sql

Subqueries are also called inner queries and they can be used in various complex operations in SQL.

Subqueries help in executing queries with dependency on the output of another query.

Subqueries are enclosed in parentheses. In this article, we will see how we can write and use subqueries in MYSQL.

MYSQL Subquery

MYSQL Subquery can be used with an outer query which is used as input to the outer query.

It can be used with SELECT, FROM, and WHERE clauses. MYSQL subquery is executed first before the execution of the outer query.

Let's Setup an Environment

Before writing queries let's create simple tables for performing operations.

We will create two tables Employee and Departments.

CREATE TABLE Employee(
empid numeric(10),
name varchar(20),
salary numeric(10),
department varchar(20)
);

CREATE TABLE Departments(
deptid numeric(10),
department varchar(20)
);

Let's add some values into these tables.

INSERT INTO Employee
VALUES (100,"Jacob A"