Sub Query - 9 --- Sub Queries

SESSION NAME: Sub Queries.

QUESTION NAME: Sub Query - 9.

TABLE DESCRIPTION:

Write a query to display all the information of the
employees whose salary is within the range of smallest
salary and 2500

Table name = sub_employees
Use Sub Queries

CODE:

SELECT *  FROM sub_employees  WHERE salary BETWEEN   (SELECT MIN(salary)  FROM sub_employees) AND 2500;