Which operator is used to select values within a range?

Question

Can anyone tell which operator is used to select values within a range?

Answer 1

We can use the BETWEEN operator to select values within a range. The following is the SQL query to return the employee details whose salary is in the range of 50,000 to 1 lakh:

SELECT E_id, E_name

FROM Employee

WHERE Sal between 50000 and 100000;

If you want to learn SQL from Industry experts then I recommend this SQL course by Intellipaat that provides Instructor-led training, hands-on experience, and certification.