How can we write JPA query for below SQL query

Question

how to write jpa query for below sql without using native sql query

select * from emp where emp_id=123 and (emp_name="ABC" OR emp_name is NULL) order by salary

Answer 1

If we say

A and (B or C) <=> (A and B) or (A and C)

then you query must look like this one below

Employee findByEmp_idAndEmp_nameOrEmp_idAndEmp_nameIsNullOrderBySalary(Long empId, String empName);