Sub Query - 8 --- Sub Queries.

SESSION NAME: Sub Queries.

QUESTION NAME: Sub Query - 8.

TABLE DESCRIPTION:

Write a query to display all the information of the
employees whose salary is within the range 1000 and
3000
Table name = sub_employees

CODE:

SELECT *  FROM sub_employees  WHERE salary BETWEEN (SELECT 1000) AND 3000;