Question

Select the suitable option for retrieving all the employees whose salary range is between
40000 and 100000?
​

Answer 1

Answer:

select name from employee

where salary between 4000 and 100000;

Answer 2

The BETWEEN operator is one of the logical operators in SQL. The BETWEEN operator checks if a value is within a range of values.

The syntax of the BETWEEN operator is as follows:

expression BETWEEN low AND high;

So for range between 40000 and 100000:

expression BETWEEN 40000 AND 100000;

#SPJ2