• Tue. Feb 27th, 2024

Trying to find Mutiple Info: MyBatis SQL

Byadmin

Dec 26, 2021


Trying to find Mutiple Info


From worth : 100000 To worth : 200000

If solely from worth is enter, data is retrieved in accordance with this search situation. If solely to worth is enter, data is retrieved in accordance with this search situation. How Can I modify the next SQL ?

SELECT A.EmpID
       A.EmpName
       B.DepID
       B.DepartmentName
FROM  Worker A, 
      Division B
WHERE A.EmpID = B.EmpID
     AND A.Wage BETWEEN'100000' AND '200000'

By admin

Leave a Reply

Your email address will not be published. Required fields are marked *