Searching for Mutiple Information: MyBatis SQL

Fashion

December 13, 2021December 23, 2021

Searching for Mutiple Information

From value : 100000 To value : 200000

If only from value is input, information is retrieved according to this search condition. If only to value is input, information is retrieved according to this search condition. How Can I change the following SQL ?

SELECT A.EmpID
       A.EmpName
       B.DepID
       B.DepartmentName
FROM  Employee A, 
      Department B
WHERE A.EmpID = B.EmpID
     AND A.Salary BETWEEN'100000' AND '200000'

sql