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
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.